[Bug 55786] FILEOPEN: read error for unsupported Lotus123 .wk3, .wk4

https://bugs.documentfoundation.org/show_bug.cgi?id=55786

osnola <alonso@loria.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |alonso@loria.fr

--- Comment #14 from osnola <alonso@loria.fr> ---
Hello,
just for note as I am working on libwps(*) on a filter for Lotus wk3, wk4
files, ... 

The following opcodes stores the main content:
- 0x16: contains the text strings, 
- 0x17: contains big float ( 10 bytes)
- 0x18: contains small int/float ( 2 bytes)
- 0x19: contains big float ( 10 bytes ) + a formula + sometimes a string (
maybe comment)
- 0x1a: contains a string ( the result of a formula )
while the opcode 0x1b stores different data : colors, font names, graphic
styles, graphic, ....

You can find some details in the file Lotus.cpp ( function
LotusParser::readZone ), LotusSpreadsheet.cpp at
http://sourceforge.net/p/libwps/code/ci/master/tree/src/lib/
( even if this is a work in progress )

(*) by error, libwps can already read the wk1 files ( which shares the same
format as MsWorks DOS Wks files ), so why not convert also the other Lotus's
files :-~

-- 
You are receiving this mail because:
You are on the CC list for the bug.