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

evaluation result of some engineering formulas are slightly different from expected

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.0.0
    • 2.5.0, 3.0.0 RC
    • ZSS Component

      problem description

      COMPLEX, IMCONJUGATE, IMDIV, IMPRODUCT,IMEXP, IMCOS, IMLN, IMLOG10, IMLOG2, IMSIN, IMSQRT, IMSUB, IMSUM, IMPOWER

      java.lang.AssertionError: =COMPLEX(3,4) failed, at row 17 in xsheet: formula-engineering
      Expected: "3+4i"
           but: was "3 + 4i"
      
      java.lang.AssertionError: =IMCONJUGATE("3+4i") failed, at row 45 in xsheet: formula-engineering
      Expected: "3-4i"
           but: was "3 - 4i"
      
      java.lang.AssertionError: =IMCOS("1+i") failed, at row 47 in xsheet: formula-engineering
      Expected: "0.833730025131149-0.988897705762865i"
           but: was "0.83373002513115 - 0.98889770576287i"
      
      java.lang.AssertionError: =IMDIV("-238+240i","10+24i") failed, at row 49 in xsheet: formula-engineering
      Expected: "5+12i"
           but: was "5 + 12i"
      
      java.lang.AssertionError: =IMEXP("1+i") failed, at row 51 in xsheet: formula-engineering
      Expected: "1.46869393991589+2.28735528717884i"
           but: was "1.46869393991589 + 2.28735528717884i"
      
      java.lang.AssertionError: =IMLN("3+4i") failed, at row 53 in xsheet: formula-engineering
      Expected: "1.6094379124341+0.927295218001612i"
           but: was "1.6094379124341 + 0.92729521800161i"
      
      java.lang.AssertionError: =IMLOG10("3+4i") failed, at row 55 in xsheet: formula-engineering
      Expected: "0.698970004336019+0.402719196273373i"
           but: was "0.69897000433602 + 0.40271919627337i"
      
      java.lang.AssertionError: =IMLOG2("3+4i") failed, at row 57 in xsheet: formula-engineering
      Expected: "2.32192809506607+1.33780421255394i"
           but: was "2.32192809488736 + 1.33780421245098i"
      
      
      java.lang.AssertionError: =IMPOWER("2+3i",3) failed, at row 59 in xsheet: formula-engineering
      Expected: "-46+9.00000000000001i"
           but: was "-46.00000000000001 + 9.00000000000001i"
      
      java.lang.AssertionError: =IMPRODUCT("3+4i","5-3i") failed, at row 61 in xsheet: formula-engineering
      Expected: "27+11i"
           but: was "27 + 11i"
      
      java.lang.AssertionError: =IMSIN("3+4i") failed, at row 65 in xsheet: formula-engineering
      Expected: "3.85373803791938-27.0168132580039i"
           but: was "3.85373803791938 - 27.01681325800393i"
      
      
      java.lang.AssertionError: =IMSQRT("1+i") failed, at row 67 in xsheet: formula-engineering
      Expected: "1.09868411346781+0.455089860562227i"
      
      java.lang.AssertionError: =IMSUB("13+4i","5+3i") failed, at row 69 in xsheet: formula-engineering
      Expected: "8+i"
           but: was "8 + 1i"
      
      java.lang.AssertionError: =IMSUM("3+4i","5-3i") failed, at row 71 in xsheet: formula-engineering
      Expected: "8+i"
           but: was "8 + 1i"
      

      reproducing steps

      run automatic test case FormulaTest of the project zss.test of zkspreadsheet or attached file

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

              Created:
              Updated:
              Resolved: