Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-715

InvalidFormulaException while importing an XLS file with formula in pt_BR Locale

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.5.0 RC
    • Fix Version/s: 3.5.0
    • Component/s: None
    • Labels:
      None

      Description

      In pt_BR locale, the decimal separator is comma (",") instead of dot ("."). This forces Excel to use ";" as formula argument separator.
      We're trying to import a sheet containing the following formula: "=ROUND(A; 2)".

      This formula works fine on ZSS-RC3.5.0 (the same as ZK ZSS online demo). But after the ZSS-565 bug fix, this seems to stop working.

      by Felipe Reis

        Activity

        Hide
        henrichen henrichen added a comment -

        Workbook data model could be shared by different users with different Locales; thus we need ONE consistent internal data format and do the conversion on Input/Output per the current locale. In this case, ExcelXlsImporter fails to use the internal Locale on imports() and thus the Exception.

        Show
        henrichen henrichen added a comment - Workbook data model could be shared by different users with different Locales; thus we need ONE consistent internal data format and do the conversion on Input/Output per the current locale. In this case, ExcelXlsImporter fails to use the internal Locale on imports() and thus the Exception.
        Show
        henrichen henrichen added a comment - 3.5 https://github.com/zkoss/zkspreadsheet/commit/33e4c30c23fcd749c619d1545614172640043ae4
        Hide
        henrichen henrichen added a comment -

        Fixed.

        Show
        henrichen henrichen added a comment - Fixed.

          People

          • Assignee:
            henrichen henrichen
            Reporter:
            henrichen henrichen
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: