Apache OpenOffice (AOO) Bugzilla – Issue 113820
TEXT function not working as expected - com.sun.star.sheet.FunctionAccess is broken
Last modified: 2017-05-20 10:33:58 UTC
steps to reproduce: run macro provided below OO 1.1.5/3.2/3.2.1 will show "--04" OOO330m3 will show "4" so i think this is a regression ... REM ***** BASIC ***** OPTION EXPLICIT Sub Main Dim oService as Object Dim mArgs(1) Dim res as Variant oService = createUNOService("com.sun.star.sheet.FunctionAccess") mArgs(0) = "4" mArgs(1) = "--0#" ' example: convert the given value to a "xs:gMonth" ... res = oService.callFunction("TEXT", mArgs()) MsgBox res End Sub
noticed: " mArgs(0) = 4 "will work, so there is a problem with text/number conversion ? btw: attached "test_format.ods" will show, that =TEXT(xVal, Format) function still accepts number/string values for xVal parameter ...
Created attachment 71050 [details] test_format
There were changes in the TEXT function, see http://eis.services.openoffice.org/EIS2/changesmails.EditFeature?Id=4698 Erroneously a text string passed as argument is treated differently from textual cell content, i.e. =TEXT("4";"--0#") is different from =TEXT(B1;"--0#") with B1:'4
Created attachment 71168 [details] test cases, augmented from issue 108385
In cws calc58: changeset 64f1e0baf188 http://hg.services.openoffice.org/cws/calc58/changeset/64f1e0baf188 M sc/source/core/tool/interpr1.cxx You can observe the progress and possible integration date of CWS calc58 at http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Path=OOO330%2Fcalc58
Reassigning to QA for verification.
verified in internal build cws_calc58