https://bz.apache.org/bugzilla/show_bug.cgi?id=62857

            Bug ID: 62857
           Summary: DOLLAR function not implemented entirely
           Product: POI
           Version: 4.0.0-FINAL
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

The evaluation result for function call DOLLAR(1234.567;2) is just the raw
numeric value itself. Without dollar sign, without thousands separators and
without cutting/extending the value to the given number of decimal places.

In Method org.apache.poi.ss.formula.functions.new Var1or2ArgFunction()
{...}.evaluate(int, int, ValueEval, ValueEval) for Function DOLLAR there is a
comment:
// TODO - DOLLAR() function impl is NQR
// result should be StringEval, with leading '$' and thousands separators
// current junits are asserting incorrect behaviour

I think it's useful to document the difference from the expected behavior here
in bugzilla, so that others can find it fast(er) when they search for
unexpected DOLLAR-behavior.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to