[Bug 123391] New: French-Localized CELL info_type "Ligne" is not portable to excel

[bu...@apache.org]

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: issues@openoffice.apache.org
          Reporter: emms@scarlet.be
                CC: issues@openoffice.apache.org

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.

[Bug 123391] French-Localized CELL info_type "Ligne" is not portable to excel

[bu...@apache.org]

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needhelp
                 CC|                            |elish@apache.org

-- 
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.