Bug 120213

Summary: Problems with opening excel files
Product: [Applications] calligrasheets Reporter: Hasso Tepper <hasso>
Component: filtersAssignee: Ariya Hidayat <ariya>
Status: RESOLVED FIXED    
Severity: normal    
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: Book1.xls
Book2.xls

Description Hasso Tepper 2006-01-16 00:08:07 UTC 
Version:           1.4 post (using KDE 3.5.0, compiled sources)
Compiler:          Target: i486-linux-gnu
OS:                Linux (i686) release 2.6.13.2-rt14

Two test *.xls files attached - Book1.xls created with Gnumeric and Book2.xls created with Pocket Excel.

1) Input line is always empty if I select any of cells with content (A1 and A2) in these files.
2) Absolute position of content in cells remains same if I resize the first column in these tables. Ie. it should be left aligned, but it isn't any more if I make column A bigger.
3) A2 in the Book2.xls is empty. No problem in OOo Calc.
Comment 1 Hasso Tepper 2006-01-16 00:08:55 UTC 
Created attachment 14265 [details]
Book1.xls
Comment 2 Hasso Tepper 2006-01-16 00:09:29 UTC 
Created attachment 14266 [details]
Book2.xls
Comment 3 Ain Vagula 2006-01-16 09:37:45 UTC 
The main problem is, why I sent these files to Hasso, that kspread does not convert values in formulas to correct locale format.
In A2 are in both files formulas =A1*0.18
When I use locale with comma-decimals, formula should be visually converted to =A1*0,18. Conversion works with single values in cell, but not with values as formula components (and formula gives 'parse' error).
Comment 4 Ariya Hidayat 2006-04-19 22:17:06 UTC 
SVN commit 531678 by ariya:

UString changes:
- remove stuff we never need
- s/from/number to match QString
- remove all @ref
- microoptimize int-to-string

some const references
Handle formula record in Pocket Excel files

BUG: 120213



 M  +2 -2      cell.cpp  
 M  +19 -13    excel.cpp  
 M  +1 -0      excel.h  
 M  +6 -6      format.cpp  
 M  +1 -1      format.h  
 M  +118 -363  ustring.cpp  
 M  +25 -82    ustring.h  
 M  +19 -4     workbook.cpp  
 M  +7 -0      workbook.h