Saving on Open office Calc spreadsheet

Discuss the spreadsheet application

Saving on Open office Calc spreadsheet

Postby BONNEBLUE » Sun Jan 27, 2008 10:18 pm

Good Morning,
I have created a list of names and addresses to use for a mail merge in this programme and I have somehow managed to confuse it, and it thinks its a Database. I have saved it in Open office Calc. When I go to open it I get this message: "Works cannot open the file you selected. the file may be corrupted or it may be a file type that the Databse cannot open. If yo have a backup copy of the file, try opening that copy, or try opening the file in the program that you created it in" I can open my spreadsheet if I go to it via the program I created it in which is open office calc but I can't use it that way in a mail merge. Is there any way I can resave it as calc or even excel? :? Any suggestions?
BONNEBLUE
 
Posts: 1
Joined: Sun Jan 27, 2008 10:04 pm

Re: Saving on Open office Calc spreadsheet

Postby thomasjk » Sun Jan 27, 2008 10:28 pm

Are you using Microsoft Works as your database? Works cannot open native Calc format files .ods. Use Save as and select 97/2000/Xp to save in Excel format. Or better yet just use BASE which is part of OOo and will handle Calc files just fine.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4431
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Saving on Open office Calc spreadsheet

Postby Dave » Mon Jan 28, 2008 3:32 am

Perhaps both use CSV files. Save from one as CSV, and open that in the other. No formatting though.

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests