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

Keikai formats a number differently from Excel

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 5.4.0
    • 5.3.0
    • None
    • None
    • None

      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

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

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

              Created:
              Updated:
              Resolved: