Issue 75775 - SYLK File from Calc Has Critical Different with the one from Ms. Excel
Summary: SYLK File from Calc Has Critical Different with the one from Ms. Excel
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2007-03-27 10:57 UTC by ramanal
Modified: 2023-01-19 15:59 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---

Attachments
This SYLK file exported from CALC. (21.33 KB, text/spreadsheet)
2007-03-27 11:03 UTC, ramanal 		no flags Details
This SYLK file exported from Excel (19.28 KB, text/spreadsheet)
2007-03-27 11:04 UTC, ramanal 		no flags Details
SYLK source, try to export to sylk from Excel and Calc to see the difference (114.00 KB, application/vnd.ms-excel)
2007-03-29 05:58 UTC, ramanal 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description ramanal 2007-03-27 10:57:32 UTC 
My user use SYLK file type as input for a UNIX application.

SYLK file exported from Ms. Excel work perfectly with the application. But not
the  SYLK file exported from CALC.

Both of them attached.
Comment 1 ramanal 2007-03-27 11:03:02 UTC 
Created attachment 43963 [details]
This SYLK file exported from CALC.
Comment 2 ramanal 2007-03-27 11:04:33 UTC 
Created attachment 43964 [details]
This SYLK file exported from Excel
Comment 3 kpalagin 2007-03-28 16:50:02 UTC 
ramanal,
I see certain differences in the files but I have no idea how you prepared 
those files.
Please provide detailed repro steps.
Comment 4 ramanal 2007-03-29 05:58:39 UTC 
Created attachment 44004 [details]
SYLK source, try to export to sylk from Excel and Calc to see the difference
Comment 5 kpalagin 2007-03-30 01:27:57 UTC 
I can confirm that Calc 2.2 produces SYLK file that is different from Excel 
2003.

ramanal,
please elaborate what specifically your Unix app does not like in file 
produced by Calc.
Thanks.
Comment 6 ramanal 2007-03-30 12:42:51 UTC 
The Unix application only inform that the sylk file has no data. Nothing more.
Comment 7 frank 2007-04-11 14:56:59 UTC 
Hi Daniel,

seems to be yours.

Adjust target as needed.

Frank
Comment 8 Martin Hollmichel 2007-11-09 16:51:58 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 9 damjan 2023-01-19 15:59:57 UTC 
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?