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
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:
Depends on:
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: ---

intersection operator sample (8.82 KB, text/plain)
2009-10-21 06:48 UTC, suhefeng
no flags Details

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
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 "".