[Solved] Edit, then save, an Excel spreadsheet

Discuss the spreadsheet application
Post Reply
hbill@yahoo.com
Posts: 5
Joined: Tue May 12, 2015 12:11 am

[Solved] Edit, then save, an Excel spreadsheet

Post by hbill@yahoo.com »

A friend sent me an Exel spreadsheet to work on. I am using Open Office on my Mac using Big Sur 11.5.2. I have made changes to the spreadsheet including new columns. When I look at it in page view none of my updates appear, and I can’t print the revised spreadsheet.
Help please
Last edited by MrProgrammer on Sat Oct 02, 2021 3:23 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Openoffice 3.4.1
Mac OSX 10.6.8
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Edit an Exel spreadsheet

Post by Zizi64 »

Is it an OOXML .xlsx or an obsolete .xls type file?

Can you upload it here?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
hbill@yahoo.com
Posts: 5
Joined: Tue May 12, 2015 12:11 am

Re: Edit an Exel spreadsheet

Post by hbill@yahoo.com »

The extension says xlsx
Openoffice 3.4.1
Mac OSX 10.6.8
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Edit an Exel spreadsheet

Post by RoryOF »

OpenOffice _cannot_ save in XLSX format. It will Save As in .xls (Microsoft Excel 97/2000/XP) format.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
hbill@yahoo.com
Posts: 5
Joined: Tue May 12, 2015 12:11 am

Re: Edit an Exel spreadsheet

Post by hbill@yahoo.com »

So, what do I do so that I can send the updated Exel, or print it? Save in the foremat you mentioned?
Openoffice 3.4.1
Mac OSX 10.6.8
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Edit an Exel spreadsheet

Post by RoryOF »

Save in either .xls format or .odt format. Since about 2007 all MS Office versions since then can read and save in .odt/.ods format, but their users don't usually know how to tell them to read such files. This is the vendor lock-in policy.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
hbill@yahoo.com
Posts: 5
Joined: Tue May 12, 2015 12:11 am

Re: Edit an Exel spreadsheet

Post by hbill@yahoo.com »

Just to clarify.
Should I save the spreadsheet as I originally got as XLS. or ODT, then make changes and re-save, or just save as XLT or ODT when I am through making changes?
Sorry to be a pest but this is making wonky!
Openoffice 3.4.1
Mac OSX 10.6.8
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Edit an Exel spreadsheet

Post by Zizi64 »

The spreadsheet file extension of the ODF (Open Document Format) file formats is the .ods. Try to save your .xls or xlsx documents into .ods format.


Or you can try the LibreOffice. It can save into OOXML file formats (.xlsx for the Microsoft spreadsheets).

Note: never was and never will be 100% compatibility between the different file formats (even there is not between the .xls and the .xlsx).
You always will lose some formatting properties (or sometimes some content!) when you convert the file formats of your document.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Bidouille
Volunteer
Posts: 574
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Re: Edit an Exel spreadsheet

Post by Bidouille »

hbill@yahoo.com wrote:Just to clarify.
or just save as XLT or ODT
ODT is for word processor. You can save as ODS.
This format is understandable by MS-Excel since 2016 edition.
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Edit an Exel spreadsheet

Post by John_Ha »

See [Tutorial] Differences between Microsoft and AOO/LO files for a description of differences and for why you should always work in, and save Writer files as .odt, Calc files as .ods, Impress files as .odp, etc.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Post Reply