When a sheet has a single quote in it's name and a formula in an other sheet refers to it and the file is saved as .xlsx it can't be opened in Excel or LibreOffice. It seems that saving a file in .xls format does not cause a problem.
We are from a french speaking part of Canada and apostrophes are used quite a lot. This could be a major annoyance for us, considering we are sharing documents with people who use MsOffice. It also causes errors in LibreOffice. We can't take the risk of corrupting a shared file.
I made some sample files that show the problem.
https://1drv.ms/u/s!AlGHhgB-_0QevQfx-vk ... x?e=XKfZmg
Single quote in sheet name / formula
-
- Posts: 15
- Joined: Wed Sep 16, 2020 8:52 pm
Re: Single quote in sheet name / formula
The link I included in the above post is for OneDrive. If you would prefer I send these files an other way, please let me know.
-
- Posts: 15
- Joined: Wed Sep 16, 2020 8:52 pm
Re: Single quote in sheet name / formula
I opened both the file saved in Excel and the one made in Planmaker and here are differences I noticed:
In _rels/xl/worksheets/sheet1.xml
Cell B2 is defined as such
In Excel:
In Planmaker:
And in _rels/xl/workbook.xml
The sheet named Aujourd'hui is defined as such
In Excel:
In Planmaker:
The apostrophes and quotes are not represented the same way in both software.
In _rels/xl/worksheets/sheet1.xml
Cell B2 is defined as such
In Excel:
Code: Select all
<c r="B1"><f>Hier!B1+'Aujourd''hui'!B1+Demain!B1</f><v>60</v></c>
Code: Select all
<c r="B1"><f>Hier!B1+"Aujourd'hui"!B1+Demain!B1</f><v>60</v></c>
The sheet named Aujourd'hui is defined as such
In Excel:
Code: Select all
<sheet name="Aujourd'hui" sheetId="3" r:id="rId3"/>
Code: Select all
<sheet name="Aujourd'hui" sheetId="3" r:id="rId6"/>
Re: Single quote in sheet name / formula
Thanks for sharing the files. I have checked the Excel file in PlanMaker 2021, PlanMaker file in Excel, and found both are working fine as shown in the attached screenshots. Please check.
This is the Excel file opened in PlanMaker 2021 This is the PlanMaker 2021 file opened in Excel
This is the Excel file opened in PlanMaker 2021 This is the PlanMaker 2021 file opened in Excel
-
- Posts: 15
- Joined: Wed Sep 16, 2020 8:52 pm
Re: Single quote in sheet name / formula
From your screenshot, I see that you opened the .xls file in Excel. As I said, .xls files don't cause this problem. Could you try opening the file named "Single_Quote_In_Sheet_Name_Created_in_Planmaker.xlsx" and see if you get the same result?
Re: Single quote in sheet name / formula
Thanks for reporting this problem. I was able to reproduce it and forwarded the details to our development team.
Re: Single quote in sheet name / formula
Our development team has fixed this problem and the solution will be included in the next service pack of SoftMaker Office.
Thank you
Thank you
-
- Posts: 15
- Joined: Wed Sep 16, 2020 8:52 pm
Re: Single quote in sheet name / formula
Thank you for taking the time to look into and fixing this problem!
This will have a major influence on our decision to ditch the Ms Suite and move to yours.
This will have a major influence on our decision to ditch the Ms Suite and move to yours.