[Solved] My customers can't open XLSX files I create

Discuss the spreadsheet application
Post Reply
Emilio
Posts: 21
Joined: Mon Nov 23, 2020 3:58 pm

[Solved] My customers can't open XLSX files I create

Post by Emilio »

Hello,
I use openoffice 4.1.7 and windows 10.
Usually I get a lot of Excel files with .xlsx fomat.
I download them, make changes and save them in the same format means .xlsx
but lately when I save the files, and send them to my customer, they have difficulties to open the file and had to find other way to send the xlsx file to them.
Tonight I downloaded the xlsx file and changed the content, then saved the document in xlsx format and tried to upload it, but I got error.
Then I thought it might be the file fomat, then I upladed the original xlsx file, and it worked.
Dose it mean that my Openoffice has a issue?
please, look at the film:
http://somup.com/crflrTbWyV
I add files to be checked if necessary.
Regards
Attachments
test3.xlsx
changed file
(14.21 KiB) Downloaded 141 times
example (12).xlsx
original file
(9.52 KiB) Downloaded 127 times
Last edited by Emilio on Tue Apr 13, 2021 7:17 pm, edited 1 time in total.
OpenOffice 4.1.7
Windows 10
User avatar
robleyd
Moderator
Posts: 5056
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: I get erro

Post by robleyd »

Whilst OpenOffice can open them, it cannot, and never has been able to, save spreadsheets in .xlsx format. The content of your file test3.xlsx appears to be a .ods file. How do you "save them in the same format means .xlsx"?
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: My customers can't open XLSX files I create

Post by Zizi64 »

NEVER rename the file extensions manually!

The Test3.xlslx file is an ODF (.ods) type document really.

Use the "File - Save as" function for the conversion - if it needed anyway.
But always better to use the real international standard ODF file formats, what is the native file format of the LO and AOO, and the Excel can open it (maybe it can open only the the 1.1 version of the ODF file format)
The newest LO Calc saves the documents into the 1.3 version of the ODF by default.
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.
Emilio
Posts: 21
Joined: Mon Nov 23, 2020 3:58 pm

Re: I get erro

Post by Emilio »

robleyd wrote:Whilst OpenOffice can open them, it cannot, and never has been able to, save spreadsheets in .xlsx format. The content of your file test3.xlsx appears to be a .ods file. How do you "save them in the same format means .xlsx"?
Please, clarify your question :-)
OpenOffice 4.1.7
Windows 10
User avatar
Hagar Delest
Moderator
Posts: 32628
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: My customers can't open XLSX files I create

Post by Hagar Delest »

Said differently, the question is: how can you save in .xlsx since AOO cannot save in that format?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Emilio
Posts: 21
Joined: Mon Nov 23, 2020 3:58 pm

Re: My customers can't open XLSX files I create

Post by Emilio »

Hagar Delest wrote:Said differently, the question is: how can you save in .xlsx since AOO cannot save in that format?
I thought I can just change the .xls to .xlsx, then it goes.
But it looks that it is not correct.
Any suggestion?
OpenOffice 4.1.7
Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: My customers can't open XLSX files I create

Post by Villeroy »

Do nothing. Keep the .xls extension. Every version of Excel handles xls properly.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Hagar Delest
Moderator
Posts: 32628
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: My customers can't open XLSX files I create

Post by Hagar Delest »

No, it doesn't work like that. If you buy a Lada car and replace the marking at the back by Ferrari, even with a nice sticker, it won't change the car.
Same for digital files.

If you really need to work with .xlsx, either use LibreOffice or buy MS Office.
But remember that .xlsx has never been designed to be compatible with anything else than MS Office. That's vendor lock-in policy.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: My customers can't open XLSX files I create

Post by RoryOF »

To change format of a file, it is necessary to apply internal filters to do so. To do this, use /File /Save As, select the desired format from the File Type dropdown, and ensure "Automatic file name extension" is checked. If you want others using MS Office to read your files, best to select Microsoft Excel 97/2000/XP (.xls) format, although in theory MS Office can read .ods format (OpenOffice's native format); most MS Office users will not know how to cope with an .ods file, so sending them an .xls file will be less hassle for you.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Emilio
Posts: 21
Joined: Mon Nov 23, 2020 3:58 pm

Re: My customers can't open XLSX files I create

Post by Emilio »

Hagar Delest wrote:No, it doesn't work like that. If you buy a Lada car and replace the marking at the back by Ferrari, even with a nice sticker, it won't change the car.
Same for digital files.
It was great example :bravo: :D :)
OpenOffice 4.1.7
Windows 10
Post Reply