[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Resolution|WORKSFORME  |FIXED
 CC||xiscofa...@libreoffice.org

--- Comment #37 from Xisco Faulí  ---
The issue got fixed by
https://cgit.freedesktop.org/libreoffice/core/commit/?id=b0067c89e6b2a4e29465d9da9a731ae30a66dce6

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

Riyadh  changed:

   What|Removed |Added

 Resolution|--- |WORKSFORME
 Status|NEW |RESOLVED

--- Comment #36 from Riyadh  ---

Starting from 5.4.7.2, the bug does not show (for me).

Version: 5.4.7.2 (x64)
Build ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU threads: 16; OS: Windows 6.19; UI render: GL; 
Locale: ar-IQ (ar_IQ); Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||0828

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

Thomas Lendo  changed:

   What|Removed |Added

 Blocks||108254


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108254
[Bug 108254] [META] Format filters (import/export) bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #35 from osnola  ---
(In reply to Horst from comment #34)
> I tried to convert WOODSCREWS.123 to LO 5.3.0.3 and it is still the old
> reported mess.
> The converted woodscrews.123 with libwps is almost perfect.
> 
> My question: In which version of LO is change made?

Currently, the conversions were done with the current source of libwps:
https://sourceforge.net/p/libwps/wiki/Home/, which also contains a filter to
convert lotus' spreadsheet file (this filter is currently used by LO to convert
wk1, wk3 and wk4 files).

The changes will appear in LO when a new version of libwps will be released(*),
integrated to LO and the following problem:
https://www.mail-archive.com/libreoffice@lists.freedesktop.org/msg184957.html
is corrected...

(*) I will probably do that in the following days.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #34 from Horst  ---
I tried to convert WOODSCREWS.123 to LO 5.3.0.3 and it is still the old
reported mess.
The converted woodscrews.123 with libwps is almost perfect.

My question: In which version of LO is change made?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #33 from Horst  ---
I tried to convert WOODSCREWS.123 to LO 5.3.0.3 and it is still the old
reported mess.
The converted woodscrews.123 with libwps is almost perfect.

My question: In which version of LO is change made?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #32 from osnola  ---
Hello,
just for note, I have added support for Lotus SmartSuite 98's files in the
current sources of libwps (and also support to read Lotus wk1,wk3,wk4,123 files
which have a password).
=> when a new version of libwps will be released and integrated to LibreOffice,
I guess that this will improve a lot the conversions (I have attached the
conversions' files that I now obtain)...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #30 from osnola  ---
Created attachment 131625
  --> https://bugs.documentfoundation.org/attachment.cgi?id=131625=edit
the current conversion of woodscrews.123 with libwps

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #31 from osnola  ---
Created attachment 131626
  --> https://bugs.documentfoundation.org/attachment.cgi?id=131626=edit
the current conversion of UNIVERSAL-CONTENT2.123 with libwps

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #29 from osnola  ---
(In reply to Tor Lillqvist from comment #27)
> Is this really "difficultyBeginner" ?

This depends what we want to add: 
- adding color's font or background cell's colors may be relatively easy (as I
have added a similar's code in libwps)
- retrieving cells borders, date/time format is a little more complicated (ie.
we can copy the code's of libwps, but this may require some refactoring in the
lotus' filter),
- while retrieving chart, ... is probably very difficult.

Now, the main problem is that the current code seems to suppose that there is
only the "123" stream in 123's file which is not true: in fact, a 123's file is
an archive file which contains different streams (which can explain some
missing data), ...

Note:
- currently, I have updated libwps to retrieve more data in Lotus SmartSuite
1997 spreadsheet files => the next libwps's release will convert these files. I
will probably try to enhance it to convert more recent lotus files in some
months.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

jan iversen  changed:

   What|Removed |Added

   Keywords|difficultyBeginner  |difficultyInteresting

--- Comment #28 from jan iversen  ---
I agree with you.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #27 from Tor Lillqvist  ---
Is this really "difficultyBeginner" ?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #26 from osnola  ---
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
0108):
+ 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 1a000310): 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
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #25 from osnola  ---
Created attachment 129914
  --> https://bugs.documentfoundation.org/attachment.cgi?id=129914=edit
new parsing of universal-content2

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

osnola  changed:

   What|Removed |Added

 Attachment #124026|0   |1
is obsolete||

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

jan iversen  changed:

   What|Removed |Added

 Whiteboard|ToBeReviewed|

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #24 from osnola  ---
Hello,
(In reply to Jose from comment #23)
> Did you commit it ?
> 
> If so can you say the reference.
> 
I just commit it (see 
https://sourceforge.net/p/libwps/code/ci/94c6921e313e132daa551b77b451fc06a70a3031/
)

Notes concerning libwps:
- currently the conversion on Lotus123 is only active when libwps is compiled
in 
  DEBUG mode and the results are worse than the LibreOffice lotus' filter
because 
  there is no code to retrieve the cells' formats,
- when it is configured with the flag --enable-full-debug, it also creates some 
  files to see what is parsed in the current repository (i.e. in this case a
file 
  MN0.ascii that I have renamed in .text)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #23 from Jose  ---
(In reply to osnola from comment #22)
> Created attachment 124026 [details]
> parsing of universal-content2
> 
> Hello,
> I modified my version of libwps to do some introspection of this file(*), 
> i.e. to obtain these file.
> 
> Notes:
> - OP_CreatePattern123 in sc/source/filter/lotus/op.cxx contains some code to
> parse 
>   the CellStyle fields that are not in libwps, ...
> - I try to read the LineStyle structures by improvisation, so there may be
> some 
>   mistakes, i.e. previously the patternId, the width, the dashId were stored
> in 1 
>   uint16_t now there are stored in 3 uint16_t
> - I try to code the reading of 0x0601, 0x0701 and 0x0008 structures, but
> there 
>   maybe some mistakes.
> - Datafe6E codes also the styles with id=0x6XXX(but I have never seems
> styles with 
>   such id in previous files...)
> 
> (*) by trying to recognize some new fields. I need to do some checking then
> I will do a commit probably tomorrow...

Did you commit it ?

If so can you say the reference.

Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #22 from osnola  ---
Created attachment 124026
  --> https://bugs.documentfoundation.org/attachment.cgi?id=124026=edit
parsing of universal-content2

Hello,
I modified my version of libwps to do some introspection of this file(*), 
i.e. to obtain these file.

Notes:
- OP_CreatePattern123 in sc/source/filter/lotus/op.cxx contains some code to
parse 
  the CellStyle fields that are not in libwps, ...
- I try to read the LineStyle structures by improvisation, so there may be some 
  mistakes, i.e. previously the patternId, the width, the dashId were stored in
1 
  uint16_t now there are stored in 3 uint16_t
- I try to code the reading of 0x0601, 0x0701 and 0x0008 structures, but there 
  maybe some mistakes.
- Datafe6E codes also the styles with id=0x6XXX(but I have never seems styles
with 
  such id in previous files...)

(*) by trying to recognize some new fields. I need to do some checking then I
will do a commit probably tomorrow...

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #21 from Jose  ---
Well, I can see that those 2 methods can read and apply the border when the
file extension is .wk3
The files attached are .123 , so there is no any method to read attributes from
that extension.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #20 from Jose  ---
Trying to fix import cell borders, the only reference I find to borders is in
lotattr.cxx:

const ScPatternAttr& LotAttrCache::GetPattAttr( const LotAttrWK3& rAttr )

void LotAttrCache::LotusToScBorderLine( sal_uInt8 nLine,
::editeng::SvxBorderLine& aBL )

The last 2 methods are the only ones deal with borders in the
sc/source/filter/lotus/   folder.

But neither of them are executed when importing a .123 file. So at the moment I
guess I have to call those methods someway to start fixing this bug.

Am I right ?

If anyone would like to aport some light he will be more than welcome.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

jan iversen  changed:

   What|Removed |Added

 Whiteboard|target:3.7.0 target:3.6.2   |ToBeReviewed

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

jan iversen  changed:

   What|Removed |Added

 Whiteboard|target:3.7.0 target:3.6.2   |ToBeReviewed

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #18 from Shubham Tibra  ---
(In reply to osnola from comment #17)
> Hello,
> 
> (In reply to Shubham Tibra from comment #15)
> > I'd like to work on this bug, is it still open to work on.
> > 
> > But I'll need some help. I am new here.
> > 
> > I didn't understand how the import code works and how it uses the file
> > format?
> > 
> > Can someone help me?
> 
> the source of the LibreOffice's filter(*) are in sc/source/filter/lotus.
> For instance, the version number of universal-content.123 (0x1005) is read in
> https://docs.libreoffice.org/sc/html/filter_8cxx_source.html#l00109, so this
> function will return eWK123...
> 
> (*) concerning older Lotus's files, there are read via the libwps's filter :
> the entry point on the source is
> http://sourceforge.net/p/libwps/code/ci/master/tree/src/lib/Lotus.cpp#l310
> ...

Got it.Thanks for the help :)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #18 from Shubham Tibra  ---
(In reply to osnola from comment #17)
> Hello,
> 
> (In reply to Shubham Tibra from comment #15)
> > I'd like to work on this bug, is it still open to work on.
> > 
> > But I'll need some help. I am new here.
> > 
> > I didn't understand how the import code works and how it uses the file
> > format?
> > 
> > Can someone help me?
> 
> the source of the LibreOffice's filter(*) are in sc/source/filter/lotus.
> For instance, the version number of universal-content.123 (0x1005) is read in
> https://docs.libreoffice.org/sc/html/filter_8cxx_source.html#l00109, so this
> function will return eWK123...
> 
> (*) concerning older Lotus's files, there are read via the libwps's filter :
> the entry point on the source is
> http://sourceforge.net/p/libwps/code/ci/master/tree/src/lib/Lotus.cpp#l310
> ...

Got it.Thanks for the help :)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #17 from osnola  ---
Hello,

(In reply to Shubham Tibra from comment #15)
> I'd like to work on this bug, is it still open to work on.
> 
> But I'll need some help. I am new here.
> 
> I didn't understand how the import code works and how it uses the file
> format?
> 
> Can someone help me?

the source of the LibreOffice's filter(*) are in sc/source/filter/lotus.
For instance, the version number of universal-content.123 (0x1005) is read in
https://docs.libreoffice.org/sc/html/filter_8cxx_source.html#l00109, so this
function will return eWK123...

(*) concerning older Lotus's files, there are read via the libwps's filter :
the entry point on the source is
http://sourceforge.net/p/libwps/code/ci/master/tree/src/lib/Lotus.cpp#l310 ...

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #17 from osnola  ---
Hello,

(In reply to Shubham Tibra from comment #15)
> I'd like to work on this bug, is it still open to work on.
> 
> But I'll need some help. I am new here.
> 
> I didn't understand how the import code works and how it uses the file
> format?
> 
> Can someone help me?

the source of the LibreOffice's filter(*) are in sc/source/filter/lotus.
For instance, the version number of universal-content.123 (0x1005) is read in
https://docs.libreoffice.org/sc/html/filter_8cxx_source.html#l00109, so this
function will return eWK123...

(*) concerning older Lotus's files, there are read via the libwps's filter :
the entry point on the source is
http://sourceforge.net/p/libwps/code/ci/master/tree/src/lib/Lotus.cpp#l310 ...

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #15 from Shubham Tibra  ---
I'd like to work on this bug, is it still open to work on.

But I'll need some help. I am new here.

I didn't understand how the import code works and how it uses the file format?

Can someone help me?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #15 from Shubham Tibra  ---
I'd like to work on this bug, is it still open to work on.

But I'll need some help. I am new here.

I didn't understand how the import code works and how it uses the file format?

Can someone help me?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #16 from Urmas  ---
What version of Lotus was that file created with?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #16 from Urmas  ---
What version of Lotus was that file created with?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #13 from yosi  ---


(In reply to Markus Mohrhard (retired) from comment #7)
> Some code pointers:
> 
> Lotus import code is in sc/source/filter/lotus/ and a file format
> specification is at
> http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF2.TXT and
> http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF1.TXT.
> 
> If you are interested in extending the support please contact me and I'll
> provide some smaller test documents.

Intersting extanding support, pls. reply, problems with simulate bug and
running on my existing version.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

--- Comment #13 from yosi  ---


(In reply to Markus Mohrhard (retired) from comment #7)
> Some code pointers:
> 
> Lotus import code is in sc/source/filter/lotus/ and a file format
> specification is at
> http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF2.TXT and
> http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF1.TXT.
> 
> If you are interested in extending the support please contact me and I'll
> provide some smaller test documents.

Intersting extanding support, pls. reply, problems with simulate bug and
running on my existing version.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

Zangune zang...@users.sourceforge.net changed:

   What|Removed |Added

 CC||Zangune@Users.SourceForge.N
   ||et
 Whiteboard|target:3.7.0 target:3.6.2   |target:3.7.0 target:3.6.2
   |EasyHack DifficultyBeginner |easyHack difficultyBeginner
   |SkillCpp|skillCpp

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

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

Zangune zang...@users.sourceforge.net changed:

   What|Removed |Added

 CC||Zangune@Users.SourceForge.N
   ||et
 Whiteboard|target:3.7.0 target:3.6.2   |target:3.7.0 target:3.6.2
   |EasyHack DifficultyBeginner |easyHack difficultyBeginner
   |SkillCpp|skillCpp

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

   Priority|highest |high

--- Comment #12 from Björn Michaelsen bjoern.michael...@canonical.com ---
(This is an automated message.)

LibreOffice development currently prioritizes bugs with the so called MAB (most
annoying bugs) -- as this bug has not run through that process (including
writing a short rationale for this bug being a candidate and other who are
watching the tracker bug silently approving that rationale etc.) its priority
is set to high. Note this is effectively no change in the urgency assigned to
this bug, as we are currently not making a difference between high and highest
and severity is untouched.

You can find out more about MABs and how the process works by contacting
libreoffice qa on irc:

 http://webchat.freenode.net/?channels=libreoffice-qa

The QA wiki page also gives you hints on how to get in contact with the team
(if IRC fails you, your next best choice is the mailing list):

 https://wiki.documentfoundation.org/QA

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

   Priority|highest |high

--- Comment #12 from Björn Michaelsen bjoern.michael...@canonical.com ---
(This is an automated message.)

LibreOffice development currently prioritizes bugs with the so called MAB (most
annoying bugs) -- as this bug has not run through that process (including
writing a short rationale for this bug being a candidate and other who are
watching the tracker bug silently approving that rationale etc.) its priority
is set to high. Note this is effectively no change in the urgency assigned to
this bug, as we are currently not making a difference between high and highest
and severity is untouched.

You can find out more about MABs and how the process works by contacting
libreoffice qa on irc:

 http://webchat.freenode.net/?channels=libreoffice-qa

The QA wiki page also gives you hints on how to get in contact with the team
(if IRC fails you, your next best choice is the mailing list):

 https://wiki.documentfoundation.org/QA

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

  Attachment #67347|application/octet-stream|application/vnd.lotus-1-2-3
  mime type||

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

  Attachment #67348|application/octet-stream|application/vnd.lotus-1-2-3
  mime type||

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

  Attachment #67347|application/octet-stream|application/vnd.lotus-1-2-3
  mime type||

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

  Attachment #67348|application/octet-stream|application/vnd.lotus-1-2-3
  mime type||

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

 CC||libreoffice@lists.freedeskt
   ||op.org

--- Comment #11 from Björn Michaelsen bjoern.michael...@canonical.com ---
adding LibreOffice developer list as CC to unresolved EasyHacks for better
visibility.

see e.g.
http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for
details

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

 CC||libreoffice@lists.freedeskt
   ||op.org

--- Comment #11 from Björn Michaelsen bjoern.michael...@canonical.com ---
adding LibreOffice developer list as CC to unresolved EasyHacks for better
visibility.

see e.g.
http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for
details

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

--- Comment #10 from Horst hom...@yahoo.com ---
Import works fine (last page data and formulas) in 3.6.2.2 rc2.

Found a few .WK4 worksheets to import but they all return a Read-Error unkown
Lotus 1-2-3 file format.

Happens in all versions that do not crash 3.5.5 til 3.6.2.2.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Markus Mohrhard markus.mohrh...@googlemail.com changed:

   What|Removed |Added

 Whiteboard|target:3.7.0 target:3.6.2   |target:3.7.0 target:3.6.2
   ||EasyHack DifficultyBeginner
   ||SkillCpp

--- Comment #6 from Markus Mohrhard markus.mohrh...@googlemail.com ---
So the value and formula import is fixed.

Sadly I won't be able to spend time on adding the other other features. I'll
make this an easy hack. The lotus file format looks easy enough and the lotus
import code is simple enough too.

This task ca be done by anybody with a little knowledge about C++.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

--- Comment #7 from Markus Mohrhard markus.mohrh...@googlemail.com ---
Some code pointers:

Lotus import code is in sc/source/filter/lotus/ and a file format specification
is at http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF2.TXT and
http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF1.TXT.

If you are interested in extending the support please contact me and I'll
provide some smaller test documents.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

--- Comment #8 from Horst hom...@yahoo.com ---
(In reply to comment #7)
 Some code pointers:
 
Thank you for your unsittlichen Antrag :) but there are 2 problems:
1) I never programmed in C++ only Delphi/Pascal, FORTRAN (miner one) but would
take me a few weeks to get into it.
2) I went over the the *.txt files and I think all of this is already
implemented (they are from 1985 DOS-version). And I could not find anything so
far for the missing pieces like BG color, Font color, Borders, Mergecenter
(WIN-version). I might be able to figure it out with Hex-Editor and a lot of
trialerror.

My recommendation for importing .123 files to LO (Excel has NO importer!!):
If you have 123/Smartsuite on your computer save the file as .XLS and then
import it to LO. If you need the Smartsuite they still sell it for around $50.-
and install it. It run ok on my Win7 64-bit but some help does not work and
some minor booboos.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

--- Comment #9 from Horst hom...@yahoo.com ---
FYI: Just remenbered that I have the new IBM/Lotus Symphony 3.0.1 installed.
This guys don't even support any 123 file formats though based on OO3.4 (I
think)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

--- Comment #1 from Horst hom...@yahoo.com 2012-09-18 19:15:12 UTC ---
Created attachment 67348
  -- https://bugs.freedesktop.org/attachment.cgi?id=67348
universal-content.123

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

--- Comment #2 from Horst hom...@yahoo.com 2012-09-18 19:16:16 UTC ---
Created attachment 67349
  -- https://bugs.freedesktop.org/attachment.cgi?id=67349
universal-content2.ods expected result

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 55066] FILEOPEN: flaws in importing 123 files

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=55066

Horst hom...@yahoo.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever Confirmed|0   |1

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs