Apache OpenOffice (AOO) Bugzilla – Issue 79854
Excel roundtrip: #MACRO? error for internal Calc functions unknown to Excel
Last modified: 2013-08-07 15:14:47 UTC
I am working with OpenOffice.orgCal for first time; and in every cell where I have a nested formula working with today and some satar time, i get this label #MACRO? each time I open the file.
Created attachment 46958 [details] task scheduled
In no way a P1 Issue, lowered to P3
Hi, not a bug but an enhancement request. Calc does not know all the translations for AddIn functions from Excel. DIAS is one of these functions. Frank
I have got the same problem and I find it very annoying. I have to edit a formula (e.g. delete and add a final bracket) to make it work again after opening saved spreadsheet.
Created attachment 55635 [details] WHen you edit cell with #MACRO?, e.g. H3 by removing and adding finall bracket you will get rid of #MACRO? error
*** Issue 99075 has been marked as a duplicate of this issue. ***
This has been an issue for several years now (Google reveals mention of this problem in 2005). Could someone just add the missing functions (WEEKNUM for one)? Thanks.
Changed the behaviour as following: When saving a spreadsheet to the XLS format, every function "F" that Excel does not understand will be written as "_xlfnodf.F". This is similar to what Excel does with its own additional functions, e.g. it writes "_xlfn.BAHTTEXT" for the BAHTTEXT function. When reading these documents, all "_xlfnodf.*" functions will be converted back to the Calc internal functions. XLS files written with previous versions (up to OOo 3.2) do not contain this function syntax. Therefore, while importing, the "DAYS" function contained in the attached documents is not recognized. The reason is that the function name is written with its localized UI name, e.g. "DAYS" in one document, and "DÍAZ" in the other.
The following functions are handled this way (listed by ODF function name): ARABIC, B, BASE, CHISQDIST, CHISQINV, COMBINA, DAYS, DECIMAL, FDIST, FINV, FORMULA, GAMMA, GAUSS, ISFORMULA, ISOWEEKNUM, MUNIT, NUMBERVALUE, PDURATION, PERMUTATIONA, PHI, RRI, SHEET, SHEETS, UNICHAR, UNICODE.
What's the exact state of this issue?
The related CWS is on its way into QA
Created attachment 67266 [details] all ODF functions unknown by Excel
dr->oc: load attached ODS document, save to XLS format (Excel 97-2003), reaload. All functions must reappear.
verified in internal build cws_dr74
Sorry to tell, but this fix is broken again due to another bugfix.
change owner
fixed in CWS OOO330/calc33stopper1
back to QA
Seen ok in cws calc33stopper1 -> verified
Seen ok into the master -> closed