3 ms·
Yes, 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 impor
by BrianEatWorld 14y ago
Yes, 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.