https://bugs.documentfoundation.org/show_bug.cgi?id=169615

            Bug ID: 169615
           Summary: Data Provider dialog shall show the least used
                    parameters
           Product: LibreOffice
           Version: 26.2.0.0 alpha0+ master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected],
                    [email protected],
                    [email protected],
                    [email protected], [email protected],
                    [email protected], [email protected]
        Depends on: 165619, 169568, 169570, 169572, 169596
            Blocks: 120219, 169581, 169608, 169609, 169610, 169612

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


the Data Provider dialog shall show the least used parameters 
from <calcext:data-mapping ...> if present:
- Database Range 
- Data Format 
- URL and optionally Identifier 
- the list of Transformations with all their parameters 


otherwise the user can not see what the file contains


example of content.xml:
<calcext:data-mappings>
<calcext:data-mapping xlink:href="file:///home/path/filename.csv" 
calcext:provider="org.libreoffice.calc.csv" calcext:frequency="0" 
calcext:id="org.libreoffice.calc.csv" calcext:database-name="DBrange">
<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"/>
... (more transformations)
</calcext:data-transformations>
</calcext:data-mapping>
</calcext:data-mappings>


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
https://bugs.documentfoundation.org/show_bug.cgi?id=169596
[Bug 169596] Data Provider 8 out of 12 Transformations are not saved to file
https://bugs.documentfoundation.org/show_bug.cgi?id=169608
[Bug 169608] Data Provider Delete Rows Transformation not saved to file
https://bugs.documentfoundation.org/show_bug.cgi?id=169609
[Bug 169609] Data Provider Swap Rows Transformation not saved to file
https://bugs.documentfoundation.org/show_bug.cgi?id=169610
[Bug 169610] Data Provider Sort Columns Transformation not saved to file
https://bugs.documentfoundation.org/show_bug.cgi?id=169612
[Bug 169612] Data Provider ‍‍Find and Replace Transformation not saved to file
-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

Reply via email to