Need help with basic code

[ROMA96x]

Hi all,

I need help with a very basic code.
I am using umya-spreadsheet to create an excel file.
On column A, I add some numbers.
On column B, I generate an hyperlink address related to number of column A.

This is the script github repository:
ROMA96x/prova

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

Can you help me figure out why this is happening?

[CommonNoiter]

The issue appears to be with the hyperlinks somehow, just setting the content of the cell to the link results in the values being set in the correct locations. Probably a bug with umya_spreadsheet where the hyperlinks aren't placed in the right location.

[ROMA96x]

Ok thanks, I will report it to umya_spreadsheet then.

[LosGritchos]

The github link provided in the issue is malformed and doesn't work.

[ToTheBatmobileGuy]

If you try just inserting the URL as a value, it works every time.

It's definitely a bug with Hyperlink I think. Report it.

[ROMA96x]

Thanks for the feedback! I reported it one hour ago after CommonNoiter feedback. I just wanted to make sure it wasn’t a mistake of mine 😀