Apache OpenOffice (AOO) Bugzilla – Issue 115245
Unable to Open Pocket Excel File
Last modified: 2023-02-01 23:45:49 UTC
I'm unable to open some of my pocket excel (.pxl) files - running OOO 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, on SuSE 11.3 (kernel 2.6.34.7-0.4- desktop) If I convert the file to Excel (.xls) using MS Windows & Active Sync), the file can be opened. The error reported is a General IO error. With the .xls file opened, trying to save it as a pocket excel file, the application takes 100% CPU and never finishes
Created attachment 72733 [details] Failing Pocket Excel File
Created attachment 72734 [details] Equivaalent XLS file
DEV300m90, linux : - Opening pxl file - OOo recognized this file as text file (ASCII filter dialog) - save xls as pxl - reproducible. Duplicate of issue 86752 ?
Ooo does believe this is a text file (ASICC filter dialog) by default - using this gives a text file that is fully of special characters, and not the spreadsheet. However in the open file dialog, I selected the pocket excel type in the list of file types. Then when I selected the pocket excel file I got the general IO error.
confirmed. ja->oc: could you please check other pxl files and pocket word files ? Maybe it's a problem related to xmerge (Info: Svante owns this project)
Some Pocket Excel files work OK - probably ~45% of my files work OK. I don't have any pocket word files to try this on - I never use Pocket Word on my PDA.
Still an issue in the latest Git. In the debug build, Ctrl+Alt+Shift+D and enabling Error logging to shell, we see: Error:java.util.EmptyStackException Editing main/xmerge/java/xmerge/src/main/resources/org/openoffice/xmerge/util/Debug.properties and setting debug.info, debug.trace and debug.error to true gets a lot of logging, which ends with: ---snip--- Current Cell : ixfe for Current Cell 9 ixfnt for Current Cell 30 TokenFactory creating operand (CELL_REFERENCE) Token : A4 Decoded Cell Reference: A4 Unrecognized byte : 30 Unrecognized byte : 1 Unrecognized byte : 0 TokenFactory creating operator Token : + Decoded Binary operator : + ---snip--- Attaching a Java debugger shows this is the stack trace when that java.util.EmptyStackException exception is thrown: Stack.peek:102 Stack.pop:84 FormulaCompiler.RPN2Infix:111 FormulaHelper.convertPXLToCalc:101 Formula.getString:208 PocketExcelDecoder.goToNextCell:222 PocketExcelDecoder.setWorksheet:183 SxcDocumentDeserializer.decode:251 SxcDocumentDeserializer.deserialize:190 Convert.convert:207 XMergeBridge$_XMergeBridge.convert:592 XMergeBridge$_XMergeBridge.importer:218 The OP said "probably ~45% of my files work OK". It appears to fail while converting a formula, so files that don't use formulas (or use unaffected formulas) are probably the ones that work OK.