The Data Provider (Data > Data Provider) does no store settings in the spreadsheet document. Steps to reproduce 1) set a data provider in a database range on whatever data format (CSV, HTML, XML or SQL) 2) Click OK to import data and close dialog. 3) Open the Data Provider again Actual result: The Data Provider settings are lost and must be re-entered. Expected result: For a given database range, the corresponding settings should be available in the dialog. Therefore the data format, the Identifier, the transformations list should be restored. The Data Provider settings should be stored in the spreadsheet document.
+1 It should be saved with the database range, going to edit that range, source is blank.
+1 from my side as well To store these settings in the document we can use the same strategy used by the solver, which is storing information using hidden named ranges. Or we could define an ODF extension to store these settings in the file (a more complicated strategy, but maybe more appropriate). Would there be any third other option?