https://bugs.documentfoundation.org/show_bug.cgi?id=169019
Bug ID: 169019
Summary: Data provider transformation settings are not read on
loading the 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]
Blocks: 120219
Created attachment 203501
--> https://bugs.documentfoundation.org/attachment.cgi?id=203501&action=edit
To be imported data
Download the attached csv file and the "DataProviderTarget.ods" file to your
PC.
Open the ods file.
Menu > Data > Data Provider.
In that dialog do these:
* in section `Source` select the database range "myImport".
* Click on the `Browse` button and select the downloaded csv file.
* in section `Transformations` select entry `Split Column` and click on `Add`
button. You get additional fields.
* In field `Separator string` insert a pipe symbol, that is | . In field
`Column index` enter 1. Click the `Apply` button below the Preview.
* in section `Transformations` click on `Add` again to insert the next `Split
Column` transformation.
* Enter the pipe symbol in the field `Separator string` and value 2 in `Column
index` field. Click the `Apply` button below the Preview.
The preview looks goood. Click on OK button.
You should have got a list with 100 popular male and female English names.
Make sure you save to extended ods format.
Save the document to a new name.
When you examine the saved file, you will find a <calcext:data-mappings>
element in the content.xml, that contains all the settings you have made in the
dialog.
Reopen the saved file. Error: The "Split column" transformations are not
applied and thus the entire record is in the first column.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=120219
[Bug 120219] [META] Data provider bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
