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/09/27 05:06:29 UTC

[Bug 121120] New: AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

          Priority: P3
            Bug ID: 121120
          Assignee: ooo-issues@incubator.apache.org
           Summary: AOO doesn't support RightB(), LeftB(),LenB() and
                    MidB() in formula
          Severity: major
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: zhanglu.aoo@gmail.com
          Hardware: All
            Status: UNCONFIRMED
           Version: AOO350-dev
         Component: code
           Product: spreadsheet

When load a xls file that contains these formulas, AOO displayed the formula as
=#NAME in the formula bar.

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

--- Comment #7 from louqle <lo...@gmail.com> ---
Created attachment 79936
  --> https://issues.apache.org/ooo/attachment.cgi?id=79936&action=edit
xls file containing the formulas

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

--- Comment #4 from SVN Robot <sv...@dev.null.org> ---
"leiw" committed SVN revision 1396491 into trunk:
#i121120 AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula
\n\n

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

Wang Lei <le...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|---                         |AOO 3.5.0

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

Zhang Lu <zh...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #79650|0                           |1
        is obsolete|                            |
  Attachment #79650|review?                     |
              Flags|                            |

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

Zhang Lu <zh...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #79650|                            |review?
              Flags|                            |

--- Comment #2 from Zhang Lu <zh...@gmail.com> ---
Created attachment 79650
  --> https://issues.apache.org/ooo/attachment.cgi?id=79650&action=edit
Add patch

Add 4 functions in spreadsheet formula. To check whether a char is DBCS with
ICU

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

louqle <lo...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |121372

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

Wang Lei <le...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |leiw@apache.org
         Resolution|---                         |FIXED

--- Comment #5 from Wang Lei <le...@apache.org> ---
The patch looks good, submit it in revision 1396491

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

Zhang Lu <zh...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Issue Type|DEFECT                      |ENHANCEMENT

--- Comment #1 from Zhang Lu <zh...@gmail.com> ---
I'm working on this feature

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

Zhang Lu <zh...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #79752|                            |review?
              Flags|                            |

--- Comment #3 from Zhang Lu <zh...@gmail.com> ---
Created attachment 79752
  --> https://issues.apache.org/ooo/attachment.cgi?id=79752&action=edit
Add patch

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

louqle <lo...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED
                 CC|                            |louqingle@gmail.com

--- Comment #6 from louqle <lo...@gmail.com> ---
verified in build 1409708 on Win7, suse 11 sp1 and Mac 10.7, open the sample
.xls file in Aoo, the formulas work well

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

[Bug 121120] AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

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

Yan Ji <ya...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |121359

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