Export to XLS and XLSX about sc-im HOT 23 CLOSED

Please give more details of this.

from sc-im.

from sc-im.

By XL you mean MS Excel?

from sc-im.

On Feb 10 09:44 -0800, Andr�s M. wrote:

By XL you mean MS Excel?

yes, xls and xlsx file formats.

from sc-im.

Do not think will implement XLS export, but only XLSX export.
It is not a priority since scim files can be exported to CSV and then open in Excel with that format.
It has more priority for example the interpretation of Excel functions during import of XLS and XLSX files, than just its values.

from sc-im.

On Feb 10 10:57 -0800, Andr�s M. wrote:

Do not think will implement XLS export, but only XLSX export.

that makes sense if xlsx is the new version. i dunno because i never use
it.

It is not a priority since scim files can be exported to CSV and then
open in Excel with that format. It has more priority for example the
interpretation of Excel functions during import of XLS and XLSX files,
than just its values.

problem with exporting to csv is the functions. if at least we could export
to csv with functions interpreted to xlsx functions, that would be grant. i
suppose could be reused to import from xls and xlsx as well.

from sc-im.

Any progress on XLSX export?

from sc-im.

None at the moment. My home computer is broken since a couple of weeks ago.

from sc-im.

Anyone else interested in this feature?? Please leave a comment and vote for it.

from sc-im.

Still have interest. Would make it easier to share work with Windows users.

from sc-im.

Take a look on this lib https://github.com/jmcnamara/libxlsxwriter
should make export very easy.

from sc-im.

Yes, this is what we need.
Not something like the actual sc-im import which is all manually..

from sc-im.

Basic xlsx export was added in latest commit. Please give it a try. REQUIREMENTS: libxlsxwriterhttps://github.com/jmcnamara/libxlsxwriter/

from sc-im.

Added format export as well. (alignment, bold, underline, foreground and background color..)
Date format convertion as well.

from sc-im.

Could you give it a try?

from sc-im.

xlsx_readformulas=1, read very simple xlsx spreadsheet with some calculation, and then export, I see the "@" in sum(A1:A5) being exported, which give error in libreoffice calc. remove the @ and it is ok for the formula.

from sc-im.

Hello. Actually, it should be removed by now. What is your complete formula in SC-IM? just "@sum(A1:A5)"?

from sc-im.

For instance, if you export the example file called "export.sc" in folder file/xlsx.. you still get the "@" in the last cell of column A??
EDIT: just tried this with that file and the "@" does not get exported. Please could you give us the complete formula?

from sc-im.

I reproduced the error with a minimal example that you can find here, using the current git version (built a few minutes ago).

I run :e! xlsx test.xlsx to export the file and when I open it in LibreOffice Calc, cell B1 contains =@SUM(A1:A10).

from sc-im.

yep. seems there was a problem with the case when replacing strings in the formulas. please try again with latest commit.

from sc-im.

Testing on 4f7142a
libreoffice calc read the file, but has to be forced to recalculate with F9
microsoft excel read and recalculate the file.
export.xlsx
input.xlsx

from sc-im.

from sc-im.

@svenn71, that seems to be a problem with libxlsxwriter or with libreoffice itself..
not really can do much of it.

from sc-im.