Sorry this post was created on error. The spreadsheet being retrieved was not the spreadsheet being saved as test. Once the column was formatted as text and retrieved properly, the issue went away.
I have a spreadsheet that has a date in one of the columns. For business reasons we add a 000 at the end. These zeroes get truncated when we puil data from the spreadsheet. (.xlsx)… Have formatted the column as text to no avail.
Any advise as to how to pull this column without truncating the zeroes when present. The same space gets filled with other numbers when applicable so I can’t just eliminate the three digits…The data looks something like this: 2018-04-10 10:10:38.000.
I’m using Aspose version 18.104.22.168. on C#.