You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2023/01/19 15:59:57 UTC

[Issue 75775] SYLK File from Calc Has Critical Different with the one from Ms. Excel

https://bz.apache.org/ooo/show_bug.cgi?id=75775

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |damjan@apache.org
             Latest|---                         |4.2.0-dev
    Confirmation in|                            |

--- Comment #9 from damjan@apache.org ---
As per Wikipedia's good summary at
https://en.wikipedia.org/wiki/Symbolic_Link_(SYLK)

Calc's SYLK has an ID record type (identifies file format and creating app) and
then only C record types (cell contents), and finally E record (end of file).
Testing on the latest Git, Calc still writes SYLK files with that structure.

Excel's SYLK has an ID record type, then P record types (cell formats), F
record type (formats), B record type (number of rows and columns), O record
type (options), F record type again, then C and E record types.

The UNIX application that refuses to open Calc's file is unlikely to be
interested in formatting, but might be looking for B record to determine the
size of the spreadsheet. Or if really dumb it might be hardcoded to Excel's ID
record, but that's unlikely.

Is this UNIX application available for us to test with? If not, are you willing
to do some testing?

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.