You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/05/28 11:21:46 UTC

[Bug 119453] New: [FromSymphony]]Import .xlsx file, fomulas using space as intersection operator will return error.

https://issues.apache.org/ooo/show_bug.cgi?id=119453

          Priority: P3
            Bug ID: 119453
          Assignee: ooo-issues@incubator.apache.org
           Summary: [FromSymphony]]Import .xlsx file, fomulas using space
                    as intersection operator will return error.
          Severity: major
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: shanzhu33@gmail.com
          Hardware: PC
            Status: UNCONFIRMED
           Version: AOO340
         Component: open-import
           Product: spreadsheet

Build info: r1327774

Steps:
1. In MSExcel2007/2010, input formula in cells which has space characters as
intersection operator in.
For example, =SUM(F2:F4 F3:F5), =(($D$12) ($D$12))
2. Save it as .xlsx.
3. Open the .xlsx file in AOO3.4.

Issue:
The Excel's intersection operator can not be translated into "!" which is the
intersection operator of AOO.
The formula will return error.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 119453] [From Symphony]]Import .xlsx file, fomulas using space as intersection operator will return error.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119453

Du Jing <bj...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |bjdujing@gmail.com
     Ever confirmed|0                           |1

--- Comment #1 from Du Jing <bj...@gmail.com> ---
confirmed,change its status

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 119453] [From Symphony]]Import .xlsx file, fomulas using space as intersection operator will return error.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119453

Shan Zhu <sh...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|[FromSymphony]]Import .xlsx |[From Symphony]]Import
                   |file, fomulas using space   |.xlsx file, fomulas using
                   |as intersection operator    |space as intersection
                   |will return error.          |operator will return error.

-- 
You are receiving this mail because:
You are the assignee for the bug.