Issue 14145 - Import/export SYLK cell annotations, C;A records
Summary: Import/export SYLK cell annotations, C;A records
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://topoi.pooq.com/h4/sylk/
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-06 03:18 UTC by Unknown
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Attached as we need it later (524.75 KB, text/spreadsheet)
2003-05-06 12:19 UTC, frank 		no flags Details
Attached as we need it later (343.51 KB, text/spreadsheet)
2003-05-06 12:20 UTC, frank 		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 Unknown 2003-05-06 03:18:54 UTC 
SYLK files that are used by warcraft III will no longer work after being loaded 
and saved in openoffice even when no changes are made. the output file is about 
3/5ths of the length of the original, and is missing what appear to be comments 
at the beggining of the file. as a result, Warcraft III can no longer read them 
properly. This problem is not present when loading and saving in excel. You can 
access the original file and the corrupted one here:
http://topoi.pooq.com/h4/sylk/

for more questions:
LunarCrisis@hotmail.com
Comment 1 frank 2003-05-06 12:19:16 UTC 
Created attachment 6047 [details]
Attached as we need it later
Comment 2 frank 2003-05-06 12:20:13 UTC 
Created attachment 6048 [details]
Attached as we need it later
Comment 3 frank 2003-05-06 12:23:41 UTC 
Hi,

as Excel itself can read the generated SYLK Files from OOo this not a
bug from OOo but one from Warcraft, So please file a bug against warcraft.

Nevertheless we discovered a new possibility to enhance our SYLK
filter and will try to integrate this. So I set the flags to
Enhancement and Target OOo Later.

Frank
Comment 4 ooo 2003-05-06 13:57:23 UTC 
This may be a slight misunderstanding. OOo currently doesn't
import/export annotations (cell comments, C;A records) from/to SYLK
format, also the formula notation of relative cell references
(RC[...]) isn't supported by OOo Calc. If WarCraft relies on the
presence of those annotations and/or formulas (the formulas in this
special notation can't even be read by Excel97) then currently this is
not a viable option, but it's also not a fault of WarCraft, please try
to use another data exchange format if possible.

Another possibility would be, that WarCraft relies on the ID record to
read ID;PWXL;N;E but OOo Calc writes ID;PSCALC3, you may try to change
that.
Comment 5 ooo 2006-11-16 18:58:59 UTC 
Better summary.
Comment 6 Marcus 2017-05-20 11:13:10 UTC 
Reset assigne to the default "issues@openoffice.apache.org".