9,670 questions
Hi Allen,
Please get the image which open the file by office365, it also report an error.
Thanks
Chris
why my XLSX file can't open by MS office, but it can open by libreoffice
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 47%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZC%3C/text%3E%3C/svg%3E)
Zhu, Chris
0
Reputation points
view_page_breaks_by_libreoffice.png
Hi developers,
I've output a XLSX format file(Page breaks in Export to Excel.xlsx), which add some page breaks in the file(rowBreaks in xl\worksheets\Sheet1.xml).
I've try to open it by MS Excel, it report an error, but it can open by libreoffice and google sheets, can you please let me what's wrong with this file and what should I do to fix it?
Please get some images from attachment.
As I can't upload the XLSX file, can you please let me know how can I send it to you?
Thanks
Chris
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
3,932 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AllenXu-MSFT 24,951 Reputation points Moderator2023-10-17T08:05:20.87+00:00 Hi @Zhu, Chris,
It looks like you are using an old Excel version 2010 from the screenshot, right? Is there any chance for you to try opening it in a newer version of Excel, for example Excel 2016/2019/2021 or Microsoft 365 Excel?
-
Zhu, Chris 0 Reputation points
2023-10-17T08:11:38.3933333+00:00 Hi Allen,
Please see the image which open the file by office365, it also report an error.
Thanks
Chris
-
Viorel 122.6K Reputation points2023-10-17T08:35:38.72+00:00 Maybe there is a problem with the tool, which is used to export the Excel file.
-
Zhu, Chris 0 Reputation points
2023-10-17T09:04:31.4166667+00:00 I want to know why the XLSX file can open by other softwares(eg. libreoffice and google sheets), but it can't open by MS office?
-
Viorel 122.6K Reputation points
2023-10-17T17:53:05.96+00:00 Probably Excel does not tolerate files that has certain deviations.
-
Zhu, Chris 0 Reputation points
2023-10-20T02:05:49.8133333+00:00 Hi Viorel,
All outputs follow ISO/IEC 29500 Standards, I can't see any deviations in the files.
Can you please help to check the XLSX file, and let me know why report this error?
Thanks
Chris
-
Zhu, Chris 0 Reputation points
2024-05-20T03:24:57.4333333+00:00 Hi Viorel,
Any developer can help on this issue?
Thanks
Chris
-
Zhu, Chris 0 Reputation points
2024-05-20T03:29:21.92+00:00 Hi Viorel,
Any developer can help on this issue?
Thanks
Chris
Sign in to comment