Issue 107375 - Calculation of named fields failes after importing from MS-Excel
Summary: Calculation of named fields failes after importing from MS-Excel
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO310m11
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-12-02 10:14 UTC by dreicad
Modified: 2009-12-02 10:32 UTC (History)
1 user (show)

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


Attachments
on RECAPITULATION check colum I cell I6 and following (70.00 KB, application/vnd.ms-excel)
2009-12-02 10:16 UTC, dreicad
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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