OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

.WKS to ?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
azler
Newbie
Newbie


Joined: 24 May 2012
Posts: 2

PostPosted: Thu May 24, 2012 7:47 am    Post subject: .WKS to ? Reply with quote

Not sure if this is the right section but here goes.

I recently updated an old computer with a new one on windows 7 and Open Office.
On the old computer there was 100's of .WKS files made by MS works 4.5.

I have works 4.5 installed on a test computer and they still open fine, But I cant seem to get the WKS files to open with open office.

Does anyone know how I can A) get them to open & B) convert them to a better format? .xls or something with more support.

As I have so many files a batch conversion would be nice.

Az
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu May 24, 2012 9:09 am    Post subject: Reply with quote

This software can handle quite a few foreign file formats fairly well but no software is able to handle each and every cryptic file format of computing history. For best results you need MS software to convert from one MS file format into another MS file format.
You may also try http://zamzar.com and see if it yields satisfying results.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Corfy
Moderator
Moderator


Joined: 14 Jun 2005
Posts: 1117
Location: Near Indianapolis, IN, USA

PostPosted: Thu May 24, 2012 9:18 am    Post subject: Reply with quote

I don't have a .wks file to try, but I know LibreOffice Writer handles .wps (Works word processing) files just fine.

.wks does appear to be a file format LibreOffice Calc can open, but it seems to be associated with Lotus 1-2-3 files. I don't know how different Works files are.
_________________
Laugh at life or life will laugh at you.
Back to top
View user's profile Send private message Visit poster's website
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Thu May 24, 2012 9:23 am    Post subject: Reply with quote

Libreoffice can open .wps files. .WKS files are Works spreadsheet files. Unless you can save them in .xls format you are out of luck. Or use www.zamzar.com as Villeroy suggested.
Back to top
View user's profile Send private message
Arineckaig
OOo Advocate
OOo Advocate


Joined: 01 Mar 2004
Posts: 358

PostPosted: Thu May 24, 2012 10:35 am    Post subject: Reply with quote

azler post:
Quote:
I have works 4.5 installed on a test computer and they still open fine,

Works 4.5 will save its spreadsheets as Excel (.xls) files whch can then be opened with OpenOffice and saved as Calc files.
_________________
When this issue has been resolved, it helps other users of the forum if you add the word [Solved] to the Subject line of your 1st post (edit button top right).
OOo 3.4.1 and MySQL on MS Windows XP and Ubuntu
Back to top
View user's profile Send private message
azler
Newbie
Newbie


Joined: 24 May 2012
Posts: 2

PostPosted: Thu May 24, 2012 11:30 pm    Post subject: Reply with quote

I can get the spread sheets open in works 4.5 & works 9.

My trouble is converting 100's as I cant sit there and open / save all of them it would take me days.

Az
Back to top
View user's profile Send private message
Arineckaig
OOo Advocate
OOo Advocate


Joined: 01 Mar 2004
Posts: 358

PostPosted: Thu May 24, 2012 11:54 pm    Post subject: Reply with quote

Quote:
open / save all of them it would take me days

Do you really need to? Generally it is only necessary to convert old files from Works to OpenOffice as and when they are needed. In many cases so long as you have the MS Works program there may not even be a need to convert some files. Works may be primitive by comparison with OpenOffice but it does have the great advantage of simple reliability if you are already familiar with it.
_________________
When this issue has been resolved, it helps other users of the forum if you add the word [Solved] to the Subject line of your 1st post (edit button top right).
OOo 3.4.1 and MySQL on MS Windows XP and Ubuntu
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group