TableExport icon indicating copy to clipboard operation
TableExport copied to clipboard

Exporting to xlsx shows wrong value.

Open TopStar323 opened this issue 6 years ago • 2 comments
trafficstars

TableExport is excellent. it is helping me much. While using this library, I found an issue. If a cell contains long string, xlsx file shows wrong value "#####################.... " This value is shown in that cell. I`m not sure if this is because the size of string is long or something else? as for txt, csv file formats, it returns correct value. But not for only xlsx. Would somebody kindly check this issue and tell me the solution. Best Regards.

TopStar323 avatar Jun 05 '19 22:06 TopStar323

I have the same problem. Is the text contains numbers?

iwanchan avatar Aug 15 '19 05:08 iwanchan

are you sure this isn't an excel thing? expand your excel column all the way. excel can sometimes mask values with a bunch of # signs if the column is too narrow.

mgd722 avatar Apr 01 '20 23:04 mgd722