https://bugs.documentfoundation.org/show_bug.cgi?id=169570
Bug ID: 169570
Summary: Data Provider Transformation Replace Null for 0 and
empty fields
Product: LibreOffice
Version: 25.8.0.0 alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected],
[email protected],
[email protected],
[email protected],
[email protected]
Depends on: 165619, 169568
Blocks: 120219
Created attachment 204142
--> https://bugs.documentfoundation.org/attachment.cgi?id=204142&action=edit
example CSV file 8 Col x 16 lines with 0 values and empty fields
+++ This bug was initially created as a clone of Bug #169568 +++
+++ 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 5x3numbersN.csv
Transformations: Replace Null [ADD]
Replace Null: Replace with: NUL, Column Index 1;2;3;4;5;6;7;8
Preview [Apply]:
- 0 are not replaced (example lines 2 and 7 Col 4)
- empty fields are not replaced, depending on the position (see EXAMPLE: below)
same result if imported with [OK]
EXPECTED BEHAVIOR:
"Replaces null or missing data in the list of columns with the supplied text"
EXAMPLE:
5x3numbersN.csv example:
1 8
1 1 0
1,4 2 4
1,5 3 5
1,6 4 6
1,7 5 7
1 1 0
1,4 2 4
1,5 3 5
1,6 4 6
1,7 5 7
1,6 4 6
1,7 5 7 2 6 4 1
1,7 5 7
1,5 2 3 5 8
example result:
1 NUL NUL NUL NUL NUL NUL 8
1 NUL 1 0 NUL NUL NUL NUL
1,4 2 NUL 4 NUL NUL NUL NUL
1,5 NUL 3 5 NUL NUL NUL NUL
1,6 4 NUL 6 NUL NUL NUL NUL
1,7 NUL 5 7 NUL NUL NUL NUL
1 NUL 1 0 NUL NUL NUL NUL
1,4 2 NUL 4 NUL NUL NUL NUL
1,5 NUL 3 5 NUL NUL NUL NUL
1,6 4 NUL 6 NUL NUL NUL NUL
1,7 NUL 5 7 NUL NUL NUL NUL
1,6 4 NUL 6 NUL NUL NUL NUL
1,7 NUL 5 7 2 6 4 1
NUL NUL NUL NUL NUL
1,7 NUL 5 7 NUL
1,5 2 3 5 8
empty fields' replacement:
obviously the lines are processed and columns are recognized from bottom to top
--> empty columns shall be recognized (lines 16, 15, 14 Col 5, 6, 7)
--> consider also the case that the _last_ columns are empty in the last lines
or even the CSV is not rectangular
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
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=120219
[Bug 120219] [META] Data provider bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=165619
[Bug 165619] ROUND function in Data Provider numeric transformation is
ineffective
https://bugs.documentfoundation.org/show_bug.cgi?id=169568
[Bug 169568] Exponent function in Data Provider numeric transformation is
ineffective
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
