Ask Your Question
0

wrong values with --convert-to csv->xlsx

asked 2019-10-17 17:22:11 +0100

Trey gravatar image
soffice.bin   --headless --convert-to xlsx  c:\temp\03356298_20191010163949.csv --infilter=CSV:59,34,34 --outdir c:\temp\

some calls have value like "INF" or first char was deleted For example image description

image description

edit retag flag offensive close merge delete

Comments

4

That is expected, if you don't specify types of the columns. Your column B needs to be treated as text; but if you don't tell LO, it will try to detect numbers. And in line 181, it will find e-notation and try to create a number 731038e487 = 731038*10^487, which is outside of the range representable in Calc; and in line 183, it will manage to convert the value to number, naturally loosing leading (insignificant in number) zero.

See token 5 at https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options.

Mike Kaganski gravatar imageMike Kaganski ( 2019-10-17 17:35:59 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-10-18 09:58:23 +0100

Trey gravatar image

Mike Kaganski thx, it works!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-10-17 17:22:11 +0100

Seen: 31 times

Last updated: Oct 18