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

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
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 roadmap
( 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
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.
Alex Janssen
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.