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

Issue 121120 - AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

Summary: AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

Attachments
Add patch (15.57 KB, patch) 2012-09-27 03:10 UTC, Zhang Lu	no flags	Details \| Diff
Add patch (17.71 KB, patch) 2012-10-09 09:43 UTC, Zhang Lu	zhanglu.aoo: review?	Details \| Diff
xls file containing the formulas (13.50 KB, application/vnd.ms-excel) 2012-11-22 02:55 UTC, louqle	no flags	Details
Show Obsolete (1) 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 Zhang Lu 2012-09-27 03:06:29 UTC

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

Comment 1 Zhang Lu 2012-09-27 03:07:09 UTC

I'm working on this feature

Comment 2 Zhang Lu 2012-09-27 03:10:02 UTC

Created attachment 79650 [details]
Add patch

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

Comment 3 Zhang Lu 2012-10-09 09:43:27 UTC

Created attachment 79752 [details]
Add patch

Comment 4 SVN Robot 2012-10-10 07:08:37 UTC

"leiw" committed SVN revision 1396491 into trunk:
#i121120 AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula \n\n

Comment 5 Wang Lei 2012-10-10 07:12:12 UTC

The patch looks good, submit it in revision 1396491

Comment 6 louqle 2012-11-22 02:54:12 UTC

verified in build 1409708 on Win7, suse 11 sp1 and Mac 10.7, open the sample .xls file in Aoo, the formulas work well

Comment 7 louqle 2012-11-22 02:55:11 UTC

Created attachment 79936 [details]
xls file containing the formulas