Re: Problem with ssconvert

[Morten Welinder <mortenw gnome org>]

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

Morten






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:
> 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
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list