ssconvert -T Gnumeric_stf:stf_csv [[INPUT_FILE]] [[OUTPUT_FILE]]The spreadsheet has some % values where the % sign is not mandatory. So user can put 12 or 12%, they should both be understood as 12 percent.
My issue is after running the ssconvert, the csv values are not correct anymore as you can see below (xls being my original value and csv the result of ssconvert)
| Xls | Csv |
-----------------
| 120% | 1.2 |
| 120 | 120 |
| 1.2 | 1.2 |
| 1.2% | 0.012 |
As you can see, if I have as a result 1.2, there is no way to know if the user meant 120% or simply 1.2Do you know a good trick to avoid that ? Ideally I would like the output to be the exact same thing as my original file:
| Xls | Csv |
-----------------
| 120% | 120% |
| 120 | 120 |
| 1.2 | 1.2 |
| 1.2% | 1.2% |
Or if the % sign is skipped on the CSV, doesn't matter too much :)You can find this question as well on stackoverflow:
http://stackoverflow.com/questions/25746466/ssconvert-xls-to-csv-reformat-values
Any help would be really appreciated ! Thanks in advance
Remi