Menu

#226 Add .wks ( Lotus 123 ?) support

open
None
3
2014-08-24
2008-09-01
Ian Little
No

Xena does not recognise .wks (MS Works Spreadsheet).

Guesses as "Legacy Image".

Sample attached.

Discussion

  • Ian Little

    Ian Little - 2008-09-01
     
  • Ian Little

    Ian Little - 2008-09-01
    • summary: Add .wks (works) support --> Add .wks ( Lotus 123 ?) support
     
  • Ian Little

    Ian Little - 2008-09-01

    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

     
  • Ian Little

    Ian Little - 2008-09-01

    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.

     
  • Ian Little

    Ian Little - 2008-09-01
     
  • Ian Little

    Ian Little - 2008-09-01

    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

     
  • Ian Little

    Ian Little - 2008-09-02
     
  • Ian Little

    Ian Little - 2008-09-02

    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

     
  • Michael Carden

    Michael Carden - 2010-04-08
    • priority: 1 --> 3
    • assigned_to: mcarden --> jwaddell
     
  • Michael Carden

    Michael Carden - 2010-04-08

    Are these files handled by the current OOo?

     
  • Daniel Black

    Daniel Black - 2010-11-23
    • assigned_to: jwaddell --> nobody
     
  • Daniel Black

    Daniel Black - 2011-01-18

    seems to be.

     
  • Daniel Black

    Daniel Black - 2011-01-18
    • assigned_to: nobody --> matthewoliver
     
  • Allan Cunliffe

    Allan Cunliffe - 2011-01-20

    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).

     

Log in to post a comment.