Posts

Showing posts from April, 2014

Displaying csv file with "leading-0" in Ubuntu LibreOffice

Image
1. Make the special column as "text" when opening it in LibreOffice When you use LibreOffice to open the csv file with columns with leading-0 as in column "BoekstukNr" as below. You will have a setting page when you open the csv file. Except the general settings for all the columns (number will be recognized as number without leading-0, strings will be recognized as strings) in "Separator options" and "Other options", it is important that you still need to set more in Fields. Otherwise LibreOffice will not know that you want to display a column in a specific type. Especially for a date type, it is recognized as number in LibreOffice and MS excel. In the Fields part, you first select the column with leading-0, then change the "Column type " in place 2 to "Text", then after you open it, the leading-0 will be kept. Note: if you do not set it here and opened the csv file, then the leading-0s are already gone. Even you set in a...