[Libreoffice-bugs] [Bug 127062] Importing a CSV with "0123" as a value removes the leading 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127062 --- Comment #4 from Ben --- Thanks m.a.riosv :) "Format quoted field as text" creates the behaviour I was after. Not sure how I missed that. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127062] Importing a CSV with "0123" as a value removes the leading 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127062 --- Comment #3 from m.a.riosv --- Please attach a sample with a couple of lines. Do you see in the import window "Format quoted field as Text" -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127062] Importing a CSV with "0123" as a value removes the leading 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127062 Ben changed: What|Removed |Added Status|RESOLVED|CLOSED --- Comment #2 from Ben --- That is a workaround but I think that if the value is wrapped in a string delimiter then it should be treated like a string and preserved (and if not, it can be treated like a number). In this example 0123,"0123" would import as 123,0123 Other cases like "0/10" will preserve the 0 and this feels inconsistent. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127062] Importing a CSV with "0123" as a value removes the leading 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127062 m.a.riosv changed: What|Removed |Added Resolution|--- |NOTABUG CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |RESOLVED --- Comment #1 from m.a.riosv --- You can click on the head of the column and select Text as type. https://help.libreoffice.org/6.3/en-US/text/scalc/guide/csv_files.html?DbPAR=CALC#bm_id892361 Please do your questions in Ask.libreoffice.org -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs