OpenXMLFilter: Excel "Exclude columns" option not working
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.
Comments (6)
-
Account Deleted -
Account Deleted 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 -
Account Deleted 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.
-
Account Deleted Comment 4. originally posted by @ysavourel on 2015-03-18T18:42:28.000Z:
-
-
assigned issue to
- edited description
-
assigned issue to
-
- changed status to resolved
Fixed.
- Log in to comment
Comment 1. originally posted by @ysavourel on 2014-02-10T12:08:38.000Z:
Related to comment 33.8