Added number transformations for external data

Desktop / LibreOffice - Vikas [gmail.com] - 8 July 2018 20:33 EDT

- Round allows you to round the numbers in the column up to a given number of decimal places- Round Up rounds the numbers in the column up to the nearest whole number- Round Down rounds the numbers in the column down to the nearest whole number- Absolute Value returns the absolute value of the numbers in the column- Logarithm- Natural returns the natural logarithm- Base-10 returns the base-10 logarithm- Cube returns the cube of the numbers- Square returns the square of the numbers- Square Root returns the square root of the numbers- Is Even returns TRUE if the values in the column are eve- Is Odd returns TRUE if the values in the column are odd
- Sign returns 1 if the values in the column are positive, -1 if they are negative, and 0 otherwise.

Change-Id: I7458d0d61da3749fe497b3999449373234391b04 Reviewed-on: https://gerrit.libreoffice.org/56886

510073cf0471 Added number transformations for external data
sc/qa/unit/datatransformation_test.cxx | 213 ++++++++++++++++++++
sc/source/ui/dataprovider/datatransformation.cxx | 236 +++++++++++++++++++++++
sc/source/ui/inc/datatransformation.hxx | 19 +-
3 files changed, 467 insertions(+), 1 deletion(-)

Upstream: cgit.freedesktop.org


  • Share