Apache OpenOffice (AOO) Bugzilla – Issue 123391
French-Localized CELL info_type "Ligne" is not portable to excel
Last modified: 2014-01-15 07:32:20 UTC
Created attachment 81682 [details] Cell function In the CELL function the first parameter Info_type is not portable to Excel in its French Localized version. French-style CELLULE formula accepts a fixed list of Infotype matching the enumarated list of the english version. Enumarated string "Ligne" once exported to XLS, is not understood by english excel. See http://wiki.openoffice.org/wiki/FR/Documentation/Calc:_fonction_CELLULE compared to http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CELL_function Workaround: use word "Row" instead of "Ligne" as parameter in the french-localized openoffice will solve this issue, english "row" in accepted as a synonym. Is is accepted and then the file becomes portable. Wish: the name of all the formulas are changed from english to french, the ODS file can be opened in any language, so should be their enumerated parameters. Wiki doc should be adjusted to propose the described work around. Bug similar to Bug_ID: 58794