Issue 123391

Summary: French-Localized CELL info_type "Ligne" is not portable to excel
Product: Calc Reporter: emms
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues
Version: 3.4.1Keywords: needhelp
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Cell function none

Description emms 2013-09-30 11:00:49 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