in reply to How can I use Spreadsheet::WriteExcel to write a url label without formatting it (turning ints to floats)

Are you sure Spreadsheet::WriteExcel is the culprit? I imagine you see the formatted version of your number in the cell, but what do you see in the function bar when you click on the cell?

I pasted 270751343164 into an Excel sheet and through the magic of changing the cell's width saw the value change between: ###, 3E+11, 2.71E+11 and 2.70751E+11. The function bar always displayed the correct value, however.

Try the write_string method and see if your numbers look better.

  • Comment on Re: How can I use Spreadsheet::WriteExcel to write a url label without formatting it (turning ints to floats)
  • Download Code

In Section Seekers of Perl Wisdom