computerline1z / okapi

Automatically exported from code.google.com/p/okapi
0 stars 0 forks source link

Open XMLFilter Excel options not working #390

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
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.

Original issue reported on code.google.com by sven.ste...@gmail.com on 10 Feb 2014 at 9:25

GoogleCodeExporter commented 9 years ago
Related to #338

Original comment by yves.sav...@gmail.com on 10 Feb 2014 at 12:08

GoogleCodeExporter commented 9 years ago
Hi, 

do you know when this will get fixed? Thanks!

Regards
Sven

Original comment by sven.ste...@gmail.com on 17 Feb 2014 at 4:33

GoogleCodeExporter commented 9 years ago
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.

Original comment by tingley on 8 Mar 2015 at 5:44