[Xena-devel] [ xena-Feature Requests-2086072 ] Add .wks ( Lotus 123 ?) support

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

Feature Requests item #2086072, was opened at 2008-09-01 13:44
Message generated for change (Comment added) made by acunliffe
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=577092&aid=2086072&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: Open
Resolution: None
Priority: 3
Private: No
Submitted By: Ian Little (ian_little)
Assigned to: Matthew Oliver (matthewoliver)
Summary: Add .wks ( Lotus 123 ?) support

Initial Comment:
Xena does not recognise .wks (MS Works Spreadsheet).

Guesses as "Legacy Image".

Sample attached.


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

>Comment By: Allan Cunliffe (acunliffe)
Date: 2011-01-20 12:30

Message:
Tested in Open Office - OOO330m18 (build 9556):

I can open a test WKS file OK.

Tested in Xena stable (v5.0.0):

Xena identifies the file as a Windows Cursor Image and it fails
normalisation with the following error:

org.im4java.core.CommandException
Trace:
au.gov.naa.digipres.xena.kernel.normalise.NormaliserManager.parse(NormaliserManager.java:826)
au.gov.naa.digipres.xena.kernel.normalise.NormaliserManager.normalise(NormaliserManager.java:1005)
au.gov.naa.digipres.xena.core.Xena.normalise(Xena.java:599)
au.gov.naa.digipres.xena.core.Xena.normalise(Xena.java:543)
au.gov.naa.digipres.xena.litegui.NormalisationThread.normaliseFile(NormalisationThread.java:328)
au.gov.naa.digipres.xena.litegui.NormalisationThread.normaliseStandard(NormalisationThread.java:250)
au.gov.naa.digipres.xena.litegui.NormalisationThread.run(NormalisationThread.java:191)

I should note that Xena and OO.org do not support Lotus Suite file formats
(Wordpro or 123 spreadsheets).

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

Comment By: Daniel Black (grooverdan)
Date: 2011-01-18 17:41

Message:
seems to be.

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

Comment By: Michael Carden (mcarden)
Date: 2010-04-08 12:23

Message:
Are these files handled by the current OOo?

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

Comment By: Ian Little (ian_little)
Date: 2008-09-02 11:03

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

OK, I found a wks file identified as MS Works.  It was not identified as
'Lotus' by OO and had some character set trouble when opened.  
When run through Xena it was identified and 'Normalised' as a Binary.
Attatching sample file.
File Added: TESTAWKS.WKS

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

Comment By: Ian Little (ian_little)
Date: 2008-09-01 17:01

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

OK, I found a wks file identified as MS Works.  It was not identified as
'Lotus' by OO and had some character set trouble when opened.  
When run through Xena it was identified and 'Normalised' as a Binary.
Attatching sample file.
File Added: TESTAWKS.WKS

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

Comment By: Ian Little (ian_little)
Date: 2008-09-01 16:52

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

One more comment - While Xena does not correctly identify these, Open
Office does recognise them as Lotus files and opens the file.

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

Comment By: Ian Little (ian_little)
Date: 2008-09-01 13:55

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

Hmm, it looks like MS Works and Lotus 123 share a Spreadsheet file type
"WKS".  
The website I borrowed this file from says it is "Lotus 123 Compatible".
Whereas Wikipedia says that Work's format is Proprietary.
Further scrutiny suggests that wks is used by older versions of Lotus 123
and as such is unlikely to be a priority for normalisation.
I will search on for MS works files to play with.
Ian 

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

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