[Xena-devel] [ xena-Bugs-1676950 ] sylk file guessed as plaintext

[SourceForge.net <no...@so...>]

Bugs item #1676950, was opened at 2007-03-09 03:36
Message generated for change (Settings changed) made by mcarden
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=577089&aid=1676950&group_id=85722

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: John (vombatus)
Assigned to: michael (mcarden)
Summary: sylk file guessed as plaintext

Initial Comment:
For some bizarre reason, I decided to try to normalise a sylk file (a fairly old spreadsheet format - http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK))

This was guessed and normalised as plain text. It should be normalised as an office document. OpenOffice.org can handle sylk files

----------------------------------------------------------------------

Comment By: Ian Little (ian_little)
Date: 2008-08-13 04:22

Message:
Logged In: YES 
user_id=2125694
Originator: NO

Xena correctly identified SYLK files ("SYLK Spreadsheet") and successfully
normalised.

Can close.

Ian

----------------------------------------------------------------------

Comment By: John (vombatus)
Date: 2007-12-17 01:21

Message:
Logged In: YES 
user_id=1606691
Originator: YES

Sylk file attached

There is also a sample on the testing share at /_Test/DPR
testing/Andys_transfers/transfer_95/
File Added: sylk4.slk

----------------------------------------------------------------------

Comment By: Chris Smart (csmart)
Date: 2007-12-17 00:20

Message:
Logged In: YES 
user_id=1810579
Originator: NO

Anyone for an sylk file we can test with? Please attach.

-c

----------------------------------------------------------------------

Comment By: Justin Waddell (jwaddell)
Date: 2007-03-09 05:57

Message:
Logged In: YES 
user_id=1417827
Originator: NO

I actually looked at this problem last year, but I've fixed it now. The
problem was that openoffice needs some kind of spreadsheet extension on a
file for it to know it's a spreadsheet-type file. OOo doesn't seem to need
the extension for MS files, I assume it uses the MS magic number. We used
to copy input files to a temporary file with no extension before passing to
OOo for conversion, so sylk files would not be recognised as spreadsheet
files and thus would fail conversion to ods format. I'm now adding the
appropriate ODF extension to the temporary files before conversion. Sylk
files are given an .ods extension, and OOo now recognises it correctly. Of
course this means that MS word documents are being given the .odt
extension, but it still seems to work.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=577089&aid=1676950&group_id=85722