OpenXMLFilter: Excel "Exclude columns" option not working
Created by: Anonymous
Original issue 390 created by sven.steuer... on 2014-02-10T09:25:30.000Z:
What steps will reproduce the problem?
- Use M24 apps
- Add an xlsx file with 3 columns to Rainbow (okf_openxml Filter)
- Edit the document properties and create a copy of the default filter
- Edit the filter configuration at "Excel Options"
- Check the box at "Exclude Marked Coumns in Each Sheet"
- At "Sheet1 Columns to Exlude" choose A and C
- Click OK
- Execute your custom pipeline
What is the expected output? What do you see instead?
Result:
No matter what you are choosing in "Excel options" or which steps you have in your pipeline all cells/columns are extracted from the excel file
Expected:
The expected output would be that only column B is extracted
What version of the product are you using? On what operating system?
okapi-apps_win32-x86_64_0.24 Win7
Please provide any additional information below.