Issue 123391 - French-Localized CELL info_type "Ligne" is not portable to excel
Summary: French-Localized CELL info_type "Ligne" is not portable to excel
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp
Depends on:
Blocks:
 
Reported: 2013-09-30 11:00 UTC by emms
Modified: 2014-01-15 07:32 UTC (History)
2 users (show)

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

Attachments
Cell function (7.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-09-30 11:00 UTC, emms 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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