Issue 106121

Summary:

oox: Intersection operator can not be filtered correctly in OOXML file formula

Product:

Calc

Reporter:

suhefeng <suhefeng>

Component:

open-import

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues

Version:

OOO320m1

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
intersection operator sample	none

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