https://bugs.documentfoundation.org/show_bug.cgi?id=169596
Bug ID: 169596
Summary: Data Provider 8 out of 12 Transformations are not
saved to file
Product: LibreOffice
Version: 26.2.0.0 alpha0+ master
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],
[email protected]
Depends on: 165619, 169568, 169570, 169572
Blocks: 120219, 169581
Created attachment 204176
--> https://bugs.documentfoundation.org/attachment.cgi?id=204176&action=edit
Data Provider with 5x3numbersN.csv and all Transformations
PRECONDITION:
new Calc spreadsheet, Data > Define Range
Data > Data Provider
select Range, CSV, URL e.g. 5x3numbersN.csv from #169570
https://bugs.documentfoundation.org/attachment.cgi?id=204142
[Add] all types of transformations: see attached screen shot
save Calc file --> attached DBrangeH16-5x3numbersN-allTrsfm.ods
PROBLEM DESCRIPTION:
only few transformations are saved in the file
(this means that Data > Refresh Data Provider does not fill the expected data)
[Delete Column OK]
Delete Rows -- not saved: NOK
Swap Rows -- not saved: NOK
[Split Column OK]
[Merge Columns OK]
[Text Transformation OK]
Sort Columns -- not saved: NOK
Aggregate Functions -- not saved: NOK
Numeric -- not saved: NOK
Replace Null -- not saved: NOK
Date and Time -- not saved: NOK
Find and Replace -- not saved: NOK
data-transformations in content.xml:
<calcext:data-transformations>
<calcext:column-remove-transformation>
<calcext:column calcext:column="6"/>
</calcext:column-remove-transformation>
<calcext:column-split-transformation calcext:column="5"
calcext:separator="n"/>
<calcext:column-merge-transformation calcext:merge-string="+">
<calcext:column calcext:column="5"/>
<calcext:column calcext:column="6"/>
</calcext:column-merge-transformation>
<calcext:column-text-transformation calcext:type="lowercase">
<calcext:column calcext:column="2"/>
</calcext:column-text-transformation>
</calcext:data-transformations>
EXPECTED BEHAVIOR:
all transformations shall be saved
is it an enhancement to demand that the Data Provider dialog
shall show the least used parameters?
(otherwise the user can not see what he did before saving the file)
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
https://bugs.documentfoundation.org/show_bug.cgi?id=169570
[Bug 169570] Data Provider Transformation Replace Null for 0 and empty fields
https://bugs.documentfoundation.org/show_bug.cgi?id=169572
[Bug 169572] Data Provider Preview Context Menu hidden by dialog (gtk3)
https://bugs.documentfoundation.org/show_bug.cgi?id=169581
[Bug 169581] Data Provider Preview Context Menu changes wrong column
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
