https://bugs.documentfoundation.org/show_bug.cgi?id=169036
Bug ID: 169036
Summary: Data provider DELETEROW_TRANSFORMATION is not written
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]
Blocks: 120219
Created attachment 203516
--> https://bugs.documentfoundation.org/attachment.cgi?id=203516&action=edit
example CSV with 3 columns, label row and 100 records
Download the attached csv file to your PC.
Start a new spreadsheet. Define a database range "myImport" for range
$Sheet1.$A$2:$C$101 and make sure that "contains column labels" is unchecked
(that is in Options).
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.
* In section `Transformations` select entry `Delete Rows` and click on `Add`
* In field `Lookup value` enter text `Rank`, in field `Column index` enter 1.
Click the `Apply` button.
The preview looks good. Click on OK button.
You should have got a list with 100 popular male and female English names
without header row.
Make sure you save to extended ods format.
Save the document.
Reload the document.
Your data shows the deleted row: Rank, Males, Females
Reason is, that the transformation type DELETEROW_TRANSFORMATION is not handled
in the switch in
https://opengrok.libreoffice.org/xref/core/sc/source/filter/xml/xmlexprt.cxx?r=73a6735652dc5bbb4ac51743f41bbed3fe5d1060#4212
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.
