Re: Problem with ssconvert

Your spreadsheet is messy if you allow entry of data that way.  You will not be
able to tell the difference between one percent and one hundred percent.

That said, you can use the configurable exporter:

ssconvert -T Gnumeric_stf:stf_assistant -O 'format=preserve
separator=,' p.gnumeric p.txt


On Tue, Sep 9, 2014 at 11:48 AM, remaii sans
<ivanov_ivanovich hotmail com> wrote:
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:

Any help would be really appreciated ! Thanks in advance


gnumeric-list mailing list
gnumeric-list gnome org

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