Issue 4147

Summary: opening lotus files in either Openoffice or Staroffice.
Product: Calc Reporter: Unknown <non-migrated>
Component: codeAssignee: falko.tesch
Status: CLOSED NOT_AN_OOO_ISSUE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P4 CC: issues, martin.styan
Version: 641   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Several Lotus 1-2-3 file format examples none

Description Unknown 2002-04-19 23:15:27 UTC
Filter for lotus files i.e. wk? extensions does not work.  Am I doing something 
wrong?...can not open any lotus files, but if I save a lotus file as an excel 
file....no problem opening in Openoffice.org and/ or Star office... Our company 
has been lotus based for years...would like to use Openoffice or 
Staroffice...is it possible to convert lotus files?  Help...
Comment 1 frank 2002-04-22 12:13:28 UTC
Hi Sean,

the wk? filter is a rudimentary filter, so feel free to enhance them.

Please set the priority more precissly the next time. Maybe this
filter has a high priority for you, but not necessarily for the
project. Prio 1 or 2 are used for crashes and not available applications.

Best regards

Frank


Hi Falko,

this one seems to be yours.

Frank
Comment 2 frank 2002-04-26 16:40:55 UTC
*** Issue 4278 has been marked as a duplicate of this issue. ***
Comment 3 frank 2002-05-13 07:31:24 UTC
*** Issue 4769 has been marked as a duplicate of this issue. ***
Comment 4 rubs 2002-09-05 14:15:40 UTC
Created attachment 2728 [details]
Several Lotus 1-2-3 file format examples
Comment 5 rubs 2002-09-05 14:33:35 UTC
More insights... the OpenOffice spreadsheet filter seems to recognize 
only obsolete 1-2-3 files (.WK1). An updated filter should import 
files with extensions .123 (versions 9.x, Lotus 97), WK4, WK3 & WK1. 
I've created some very simple samples to illustrate the problem. 
Please check above. All other formats give 'Unknown file format' 
errors. (Suggestion -- change summary to 'Spreadsheet filter 
recognizes only obsolete Lotus 1-2-3 files' or similar)
Comment 6 falko.tesch 2003-10-16 12:19:37 UTC
As already stated by Frank this filter is outdated and rudimentary.
We will not continiue work on this filter.
The only filter we pro-actively work on are the MS Office 97/2k/XP ones.
Comment 7 falko.tesch 2003-10-16 12:19:50 UTC
closed
Comment 8 frank 2003-12-12 09:00:03 UTC
*** Issue 23488 has been marked as a duplicate of this issue. ***
Comment 9 frank 2004-09-01 11:19:59 UTC
*** Issue 33626 has been marked as a duplicate of this issue. ***
Comment 10 hwoarang 2006-01-02 15:22:01 UTC
*** Issue 59910 has been marked as a duplicate of this issue. ***
Comment 11 larryalk 2006-03-12 23:08:04 UTC
My issue seems to be the same as 4147 except I cannot open _any_ Lotus file into 
OO Calc whether the file is .wk1 .wks or .123.

These files import ok into gnumeric but I don't want to use that!

Larryalk
Comment 12 larryalk 2006-03-12 23:08:46 UTC
My issue seems to be the same as 4147 except I cannot open _any_ Lotus file into 
OO Calc whether the file is .wk1 .wks or .123.

These files import ok into gnumeric but I don't want to use that!

What happens is I get the very first cell in A1 but nothing else.

Larryalk