Apache OpenOffice (AOO) Bugzilla – Issue 107375
Calculation of named fields failes after importing from MS-Excel
Last modified: 2009-12-02 10:32:08 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)
Created attachment 66450 [details] on RECAPITULATION check colum I cell I6 and following
the sentence "CALC is not possible to do this operation." should be CALC is not able to do this operation
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 ***
closing duplicate