Issue 107375

Summary: Calculation of named fields failes after importing from MS-Excel
Product: Calc Reporter: dreicad <dreicad>
Component: open-importAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO310m11   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
on RECAPITULATION check colum I cell I6 and following none

Description dreicad 2009-12-02 10:14:33 UTC
A spreadsheet is made by Dassault Catia V5 R19 in excel-format. This SH is
opened in calc, some informations are cut and pasted in a new spreadsheet.
To get a price, the columns have to be added and the multiplied.
CALC is not possible to do this operation. I tested this in original MS-Excel
2000 and it worked, I added the formula in excel, and opened the file in CALC,
but the error (not calculating) remains. 
(I have autoupdate set to ON)
Comment 1 dreicad 2009-12-02 10:16:57 UTC
Created attachment 66450 [details]
on RECAPITULATION check colum I cell I6 and following
Comment 2 dreicad 2009-12-02 10:19:36 UTC
the sentence "CALC is not possible to do this operation." should be
CALC is not able to do this operation
Comment 3 niklas.nebel 2009-12-02 10:31:38 UTC
Column A has text cells. See issue 5658, which was resolved for 3.2. The
attached file works fine with 3.2 beta.

*** This issue has been marked as a duplicate of 5658 ***
Comment 4 niklas.nebel 2009-12-02 10:32:08 UTC
closing duplicate