I’m developing an Excel document with freezePane. I’m using the following code:
Although I’ve tried with this code too:
In both cases, when I open the created file with my Excel version installed on my MAC computer (Office 365 version. I also tried running it with PC under the same version) it works correctly. But if I try to open the created file with the same version of Excel
Office 365 installed on my iPad it does not work.
The iPad version also comes with the tool to freeze panes and from there we can freeze panes any way we want and the tool works correctly. What I need to achieve is to have the freeze pane tool automatically running on the position I programmed from PHPExcel
when I open it with iPad the same way that it works on the coputer versions.
So I tried a few things:
- Create an Excel document with freezePane from the software installed on MAC and not from PHP. I saved the file and I opened it from iPad and it worked correctlty.
- Another thing that I tried was opening the PHP created file with Excel installed on MAC and without doing anything else I saved it once again from the software. But when I tried to open it with iPad, frozen panes didn’t work.
- Lastly, again I opened the file created with PHP on Excel for MAC but this time I deleted the freeze pane option from the program and then I put it on again. I saved the document and this time when I opened it with iPad it worked.
What might be happening? It seems like the code used (PHPExcel) freezes panes in a different way from the way that the program does it when you freeze them manually and it is only read by the Exel versions for computer and not for iPad. But when you freeze
panes manually from the program, then all versiones read it well, including the ones for iPad. Is there any solution to create a document with frozen panes with PHPExcel and that it will work the same way when I open it on the iPad version?
Greetings and thanks in advance.