umya-spreadsheet icon indicating copy to clipboard operation
umya-spreadsheet copied to clipboard

hyperlinks saved in wrong locations

Open MarcoBelluDev opened this issue 8 months ago • 5 comments

Hi, When generating multiple hyperlinks, these are not generated in the correct position.

Script available at this repository, it's just a simple main.rs file. https://github.com/ROMA96x/prova

On column A, I add some numbers. On column B, I generate an hyperlink address related to number of column A.

At the moment, I just manually insert the numbers of col A from 0 to 9. My debug println! at row 62 show the correct output:

Row 2 -> related: https://esempio//as//numer//1
Row 3 -> related: https://esempio//as//numer//2
Row 4 -> related: https://esempio//as//numer//3
Row 5 -> related: https://esempio//as//numer//4
Row 6 -> related: https://esempio//as//numer//5
Row 7 -> related: https://esempio//as//numer//6
Row 8 -> related: https://esempio//as//numer//7
Row 9 -> related: https://esempio//as//numer//8
Row 10 -> related: https://esempio//as//numer//9
File successfully saved.

But when I opened my generated excel file, the hyperlinks are all mixed up.

B2 -> related: https://esempio//as//numer//7
B3 -> related: https://esempio//as//numer//1
B4 -> related: https://esempio//as//numer//8
B5 -> related: https://esempio//as//numer//6
B6 -> related: https://esempio//as//numer//4
B7 -> related: https://esempio//as//numer//2
B8 -> related: https://esempio//as//numer//9
B9 -> related: https://esempio//as//numer//5
B10 -> related: https://esempio//as//numer//2

Am I doing something wrong?

MarcoBelluDev avatar Jun 13 '25 09:06 MarcoBelluDev

@ROMA96x Thank you for contacting us. I have a few thoughts about this event. It is probably a bug in umya-spreadsheet.

https://github.com/ROMA96x/prova

I got a 404 error when I clicked here. I would like to check the content to clarify the problem. Please could you post the source file?

MathNya avatar Jun 17 '25 07:06 MathNya

I think there was a typo. I think the link is supposed to be https://github.com/ROMA96x/prova

c-git avatar Jun 18 '25 04:06 c-git

I think there was a typo. I think the link is supposed to be https://github.com/ROMA96x/prova

Yes, this is the correct address 😀

MarcoBelluDev avatar Jun 18 '25 05:06 MarcoBelluDev

Fixed a bug. Please get the latest version.

MathNya avatar Jun 24 '25 05:06 MathNya

Hi @MathNya ,

fix is working perfectly! Thanks again :)

MarcoBelluDev avatar Jun 25 '25 08:06 MarcoBelluDev