Bug 169568 - Exponent function in Data Provider numeric transformation is ineffective
Summary: Exponent function in Data Provider numeric transformation is ineffective
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.2.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 165619
Blocks: Data-Provider 169570 169572 169581 169596 169608 169609 169610 169612 169615
  Show dependency tree / graph
 
Reported: 2025-11-20 10:27 UTC by Michael Otto
Modified: 2025-11-22 10:57 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Attachments
5x3 numbers for exponent calculation (40 bytes, text/csv)
2025-11-20 10:27 UTC, Michael Otto 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Otto 2025-11-20 10:27:57 UTC 
Created attachment 204131 [details]
5x3 numbers for exponent calculation

+++ This bug was initially created as a clone of Bug #165619 +++

PRECONDITION:
new Calc spreadsheet, Data > Define Range 
(see e.g. Bug #169514 attachment DataRangeForDataProvider.ods)
https://bugs.documentfoundation.org/attachment.cgi?id=204066


PROBLEM DESCRIPTION:
Data > Data Provider
select Range, CSV, URL e.g. attached 5x3numbers.csv 
(1.0, 1, 0
1.4, 2, 4
1.5, 3, 5
1.6, 4, 6
1.7, 5, 7)
Transformations: Numeric [ADD], Numeric: Exponent, Column Index 1;2;3
Preview [Apply]: unchanged values, not exponent
same result if imported with [OK]


EXPECTED BEHAVIOR:
Preview shall show the e**x exponent value


Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 480ef73deef62c458e5735cd496a1d74ef408ed8
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
Comment 1 raal 2025-11-20 17:42:41 UTC 
I can confirm with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 177b3d2a88afb2dfd3e89025624d8bf62b36cda4
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded