Issue 76676 - XLS-File does not calculate with textformatted numbers
Summary: XLS-File does not calculate with textformatted numbers
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2007-04-25 04:22 UTC by acaksell
Modified: 2007-04-25 09:53 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Excel spreadsheet does not calculate on import (37.00 KB, text/plain)
2007-04-25 04:23 UTC, acaksell
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description acaksell 2007-04-25 04:22:43 UTC
When I open an Excel spreadsheet in Excel, the calculated columns and totals 
perform correctly in Excel.  When I open the same Excel spreadsheet in 
OpenOffice 2.2 Calc, the calculated columns and totals do not calculate (or 
update?) and show '0' (zeros) in each column and on the total line.

PS-1> you asked me to attach a file whenever possible, but there is nowhere on 
this page to attach anything.

PS-2> The screen to change my forgotten password did not work properly in 
Firefox, so I had to switch back to Internet Explorer to get into the 
screen to reset my password.
Comment 1 acaksell 2007-04-25 04:23:57 UTC
Created attachment 44655 [details]
Excel spreadsheet does not calculate on import
Comment 2 merschmann 2007-04-25 09:16:35 UTC
Confirmed with OOo-2.2-de on Win2K

Additional information:
There are some cells which are formatted as text. Excel2003 calculates the
formulas regardless and gives a warning hint at the cells.
OOo does not calculate

In my opinion the behaviour of OOo is correct.

@acaksell: Please report your additional problems in another issue or a mailing
Comment 3 frank 2007-04-25 09:52:56 UTC

basically this is a double to Issue 2027 and a lot of others. Issue 5658 is one
of these duplicates and as feature request under evaluation.

Therefore closed double.


*** This issue has been marked as a duplicate of 5658 ***
Comment 4 frank 2007-04-25 09:53:22 UTC
closed double