Issue 18992 - Cannot open Lotus 1-2-3 2.0A .wk1 files created with SCO Procalc
Summary: Cannot open Lotus 1-2-3 2.0A .wk1 files created with SCO Procalc
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-09-03 04:17 UTC by apjjr
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Lotus 1-2-3 v2.0A files created with SCO Procalc ~1989 (205.79 KB, application/octet-stream)
2003-09-03 04:28 UTC, apjjr
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.