Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-342

Keikai formats a number differently from Excel

    XMLWordPrintable

    Details

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

      Description

      Steps to Reproduce

      1. load the attached file
      2. check C1

      Current Result

      7.9

      Expected Result

      8.0, the same as Excel

      Debug Information

      1. All formulas are the same but different formats specified. column C format: 0.0, column B format: 0.00
      2. all AVERAGE results in column B are 7.95, in column C, they should be 8.0
      3. cell values in A1:A5 are different in Keikai and Excel after show more decimal places:
      keikai:

      Excel:

      Root cause

      In Excel file, A1:A4 are:

      8.3999999999999986
      8.0999999999999979
      7.799999999999998
      7.4999999999999982

                  <c r="A1">
                      <v>8.3999999999999986</v>
                  </c>
      

      But Excel just shows them as

      8.40000000000
      8.10000000000

      7.80000000000
      7.50000000000

      Keikai's calculated result is 7.9499999, so if set to 1 decimal place, it's 7.9 instead of 8.0
      Excel's calculated result is 7.95, so with 1 decimal place, it's 8.0

        Attachments

        1. excel.jpg
          excel.jpg
          10 kB
        2. keikai.jpg
          keikai.jpg
          15 kB
        3. keikai-342.xlsx
          12 kB

          Issue Links

            Activity

              People

              Assignee:
              wenninghsu wenninghsu
              Reporter:
              hawk hawk
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: