https://bugs.documentfoundation.org/show_bug.cgi?id=55066
--- Comment #26 from osnola <[email protected]> ---
Hello,
as I have done some works in libwps to try to convert some Lotus 123
spreadsheets, I updated the introspection's result.
Some notes concerning universal-content2.text :
- in fact, a 123's file is a list of streams; the main stream is "123" but
there can be other streams if the spreadsheet contains charts, ... . The
streams' structure is stored at the end of the file, I found the same structure
to store streams in some RagTime's file, so I named it OLE1Struct (but it is
probably not related to OLE),
- 1b000a00e60f(MainStyle) is indeed important as it stored the relation between
a "major" style and its definition ; ie. we need to use it to retrieve the
cell's styles based on a major style,
- there is at least 4 different "setStyle" zones (the zones which begin
0108XXXX):
+ 01080200: define the font's cell's style,
+ 01080400: define the numbering format of a cell
+ 01080800: define the cell's borders + ???
+ 01080c00: define the column/row size, page breaking, ...
Concerning libwps, I update the code to accept to convert Lotus' 123 SmartSuite
97 spreadsheets (files which begin by 00001a000310): now, it must be able to
retrieve most cell's formatting and some basic graphic shapes.
Note: The same code seems be able to convert more recent Lotus' files but
libwps will only accept to convert them if it is compiled in debug mode.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
