3 ms·
To be fair, isn't Libre is also pretty terrible at handling more basic formats like csvs? I still have yet to find a good workaround for the "numbers as text"
by BrianEatWorld 14y ago
To be fair, isn't Libre is also pretty terrible at handling more basic formats like csvs?
I still have yet to find a good workaround for the "numbers as text" issue aside from switching to tsvs.
- maxerickson 14y agoWhat do you mean by good workaround? Specifying that the column is text during the import at least gets the data into the sheet.
- BrianEatWorld 14y agoYes, it gets data into the sheet, but means that you need extra steps to run calculations. There is no option to specify the column as a number during the import phase. So what takes one step in Excel takes a minimum of two in Libre.
- maxerickson 14y agoI thought you were worried about leading zeros or something. In calc 4.0 on XP, I can choose from a few options for each column and the default (called "Standard") results in a column that I can use in calculations (if I highlight the cells it shows the sum, in formulas, etc.). If I specify the column is "Text", leading zeros are retained.