Page 1 of 1
[Solved] Importing from Lotus 123
Posted: Fri Mar 21, 2008 9:59 pm
by Karl Griffith
Is there a way to import files from Lotus 123? I can open them, but they lose all formatting. I have been using 123 for 20 years, and have a lot of template files I don't want to have to recreate.
Re: Importing from Lotus 123
Posted: Sat Mar 22, 2008 3:32 am
by Cambirder
Not sure if it can be done in OO, but you could use Lotus Symphony to do the 123 - odf conversion
http://symphony.lotus.com/software/lotu ... /home.jspa
Re: Importing from Lotus 123
Posted: Sat Mar 22, 2008 6:25 am
by french
You didn't say which version of Lotus 123 you're using.
Newer versions can export to Excel format. OpenOffice can import Excel files.
Depending on the complexity of your files, you may suffer some changes or they may make the trip unscathed.
It's worth trying.
Re: Importing from Lotus 123
Posted: Sat Mar 22, 2008 1:40 pm
by EdH
OOo can directly import .wk4 files and .123 files with varying degrees of success. It just depends how far back your files go. If you have a modern version of 1-2-3 (97 onwards) then you should be able to convert to .xls and then open that in Calc.
Re: Importing from Lotus 123
Posted: Mon Mar 24, 2008 1:53 pm
by Boatman189
If you have any macro's they will be lost, but the save as xls conversion is what I did and it worked fine for me.