OpenXMLFilter: Excel "Exclude columns" option not working

[Former user]

Original issue 390 created by sven.steuer... on 2014-02-10T09:25:30.000Z:

What steps will reproduce the problem?
1. Use M24 apps
2. Add an xlsx file with 3 columns to Rainbow (okf_openxml Filter)
3. Edit the document properties and create a copy of the default filter
4. Edit the filter configuration at "Excel Options"
5. Check the box at "Exclude Marked Coumns in Each Sheet"
6. At "Sheet1 Columns to Exlude" choose A and C
7. Click OK
8. 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.

[Former user]

Comment 1. originally posted by @ysavourel on 2014-02-10T12:08:38.000Z:

Related to comment 33.8

[Former user]

Comment 2. originally posted by sven.steuer... on 2014-02-17T16:33:15.000Z:

Hi,

do you know when this will get fixed? Thanks!

Regards
Sven

[Former user]

Comment 3. originally posted by @ysavourel on 2015-03-08T05:44:04.000Z:

This looks like it's extra-broken. In addition to the fact that the excluded columns are still exposed as translatable text, some additional trans-units are produced that should not be. These segments contain the numeric indexes into the shared string table, which are exposed because the YAML used to translate the worksheets under normal conditions has a TEXTUNIT rule for the <v> tag. Modifying these accidentally-exposed number during translation can cause bad problems.

[Former user]

Comment 4. originally posted by @ysavourel on 2015-03-18T18:42:28.000Z:

[Chase Tingley]

Fixed.