Issue 4147 - opening lotus files in either Openoffice or Staroffice.
Summary: opening lotus files in either Openoffice or Staroffice.
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 641
Hardware: All All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: falko.tesch
QA Contact: issues@sc
URL:
Keywords:
: 4278 4769 23488 33626 59910 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-04-19 23:15 UTC by Unknown
Modified: 2006-03-12 23:08 UTC (History)
2 users (show)

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

Attachments
Several Lotus 1-2-3 file format examples (5.64 KB, application/octet-stream)
2002-09-05 14:15 UTC, rubs 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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