Issue 106121 - oox: Intersection operator can not be filtered correctly in OOXML file formula
Summary: oox: Intersection operator can not be filtered correctly in OOXML file formula
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO320m1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-21 06:45 UTC by suhefeng
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
intersection operator sample (8.82 KB, text/plain)
2009-10-21 06:48 UTC, suhefeng 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description suhefeng 2009-10-21 06:45:40 UTC 
1. Create a formula with intersection operator, like =SUM(F2:F4 F3:F5), in .xlsx
file
2. Open the file in OO32m1, the result is incorrect because that the =SUM(F2:F4
F3:F5) is not converted to =SUM(F2:F4!F3:F5)
Comment 1 suhefeng 2009-10-21 06:48:40 UTC 
Created attachment 65491 [details]
intersection operator sample
Comment 2 daniel.rentz 2009-10-21 08:43:30 UTC 
Well, someone of the inventors of the OOXML format decided that it is smart to
define an operator that equals a whitespace character...

DR->ER: Is this already known? The mapping between ' ' and '!' is set correctly
at the parser (oox/source/xls/formulabase.cxx#1105). So it is up to the parser :)
Comment 3 daniel.rentz 2009-10-21 08:44:08 UTC 
adjusted some fields
Comment 4 ooo 2009-10-21 13:32:29 UTC 
Ah, the divine smartness of operator blank..  known yes, but I think no issue
existed yet.
Comment 5 Martin Hollmichel 2011-03-15 12:51:10 UTC 
set target to 3.x since not release relevant for 3.4.
Comment 6 Marcus 2017-05-20 11:11:14 UTC 
Reset assigne to the default "issues@openoffice.apache.org".