Dear all,
First of all, apologies if I shouldn't have sent this email here.
I am looking for some help with ssconvert, and again, apologies if I am not
using the correct mailing list, or if I just shouldn't use this email list to
send such a request.
Anyway, here is my problem:
I am converting xls and xlsx files into csv using ssconver:
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.2
Do 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
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
