Problem with ssconvert



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




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]