https://issues.apache.org/ooo/show_bug.cgi?id=123391

            Bug ID: 123391
        Issue Type: DEFECT
           Summary: French-Localized CELL info_type "Ligne" is not
                    portable to excel
           Product: Calc
           Version: 3.4.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: save-export
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected]

Created attachment 81682
  --> https://issues.apache.org/ooo/attachment.cgi?id=81682&action=edit
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

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

Reply via email to