Issue 18992

Summary: Cannot open Lotus 1-2-3 2.0A .wk1 files created with SCO Procalc
Product: Calc Reporter: apjjr <alex>
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1 RC3   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Lotus 1-2-3 v2.0A files created with SCO Procalc ~1989 none

Description apjjr 2003-09-03 04:17:21 UTC 
Most of the time the OOo 1.1rc3 wk1 filter sometimes reads the first row and 
then thinks it is done and presents the file as imported. Other times it has 
just crashed the application.

I can send you some sample files if you want.
Let me know at alex@ourwoods.org
Comment 1 apjjr 2003-09-03 04:28:22 UTC 
Created attachment 8964 [details]
Lotus 1-2-3 v2.0A files created with SCO Procalc ~1989
Comment 2 frank 2003-09-03 11:27:41 UTC 
Hi Eike,

can you have a look on it ?

Excel 2k3 opens them just fine.

Frank
Comment 3 frank 2003-09-03 11:28:01 UTC 
set the target
Comment 4 ooo 2003-09-03 12:04:05 UTC 
Daniel is the owner of the Lotus filter (currently on vacation, don't
expect response before Sep-15).
Comment 5 daniel.rentz 2003-09-15 08:13:12 UTC 
accepted
problems with formula import, column width, probably more...
Comment 6 daniel.rentz 2003-09-19 15:09:33 UTC 
.
Comment 7 oc 2003-09-22 11:00:36 UTC 
According to the OpenOffice.org roadmap
(http://tools.openoffice.org/releases) this issue was retargeted to
OOo Later.
Comment 8 frank 2003-10-28 07:49:19 UTC 
no crash, so no blocking of 21786
Comment 9 apjjr 2004-06-15 04:03:07 UTC 
6/14/2004
I have discovered that loading these files in MS Excel 97 and selecting
File->Save As from the menu and saving as a .WK1 file creates a file that is
loadable by OOo 1.1.1.  This tends to prove that SCO Procalc creates a
peculiarity in the file format with which OOo 1.1.1 cannot deal, but MS Excel 97
can.  If necessary, I wlll load and resave our files as needed.  I only have a
few hundred to go.  If you find a cure for this ailment, I would be most
appreciative!  Although, it appears at this point that I may be able to muddle
through using MS Excel to translate formats, even though a little kludgy.
Thanks,
Alex Janssen
alex@ourwoods.org
Comment 10 apjjr 2005-03-18 03:17:59 UTC 
Just a note.  OOo 2.0Beta freezes when trying to open one of these files.

Alex