+++ 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
I can image to have a separate dialog for "Edit Data Provider". It could list all existing Data Provider and the user can select which one to edit. Then he gets in principle the current dialog, but filled with the values got from the existing Data Provider. That would be more flexible than remembering the last settings, because it could handle the case that a document contains more than one Data Provider. Such Edit dialog could in addition provide the option to delete this Data Provider, an option that currently does not exist at all. Would that meet your request?
(In reply to Regina Henschel from comment #1) Of course this would meet my request, but it's a rather large not smart solution. Couldn't we restrict the saved Data Provider sets to one single per Database Range value? Then the dialog could fill the saved Data Provider (if existing) when the user selects the Database Range. Ok, this does not solve the missing delete. Maybe a new Delete button in this dialog (initially grayed out) can be activated when the user selects a Database Range with existing Data Provider. (unfortunately I actually can not look at the menues as my PC's motherboard died and I have no replacement yet)
Status NEW is OK for me. Details on how to give the user better access to an existing data provider can be discussed later when a developer is going to implement it.