Hi Carl, Am 08.08.22 um 00:41 schrieb Carl Marcum: > Hi Matthias, > > On 8/7/22 5:10 PM, Matthias Seidel wrote: >> Hi Carl, >> >> Am 07.08.22 um 22:36 schrieb Carl Marcum: >>> Hi Matthias and all, >>> >>> On 8/7/22 10:08 AM, Matthias Seidel wrote: >>>> Hi, >>>> >>>> Damjan added the missing Tab function in 2015: >>>> >>>> https://bz.apache.org/ooo/show_bug.cgi?id=19221#c9 >>>> >>>> It was done in trunk (4.2.0) at that time. >>>> >>>> However it introduced a regression that was fixed now in trunk and >>>> AOO42X. >>>> >>>> @Carl: Maybe you want to add a qa test for that function? >>> Maybe if someone could give me an small example of how it would be >>> used. >>> I'm assuming it is a StarBasic function and not a Calc function. >>> Is that correct? >> Yes, StarBasic/OpenOffice Basic. >> But I am not even sure if we have tests for it? >> >> Czesław might have some code for it... > I just need an small example of a method or function in Basic that > demonstrates how one would use the Tab function and I can try to > create a test for it. Help says:
Print Statement [Runtime]
Outputs the specified strings or numeric expressions to a dialog or to a
file.
Syntax:
Print [#FileName,] Expression1[{;|,} [Spc(Number As Integer);] [Tab(pos
As Integer);] [Expression2[...]]
But I don't know if that helps.
>
> One example is the test of Clng (convert to Long) where we have a test
> spreadsheet [1] with a Basic macro in it like:
>
> Function StarBasicCLng(x As String) As Double
> StarBasicCLng = CLng(x)
> End Function
>
> In the spreadsheet we use this macro function in a formula like
> "=STARBASICCLNG(A2)" and test equality of the cell value with another
> cell.
>
> Then we have a unit test TestFormulaDocs.java [2] that opens these
> test documents and checks that the formulas worked or not.
>
> Let me know if you have any questions.
>
> [1]
> https://github.com/apache/openoffice/blob/trunk/test/testuno/data/uno/sc/fvt/StarBasicCLng.ods
> [2]
> https://github.com/apache/openoffice/blob/trunk/test/testuno/source/fvt/uno/sc/formula/TestFormulaDocs.java
The question is if we want to backport that (missing) function to AOO41X?
Regards,
Matthias
>
> Best regards,
> Carl
>
>>
>> Regards,
>>
>> Matthias
>>
>>> Thanks,
>>> Carl
>>>
>>>> @All: Would it make sense to cherry-pick this for AOO41X?
>>>>
>>>> Regards,
>>>>
>>>> Matthias
>>>>
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [email protected]
>>> For additional commands, e-mail: [email protected]
>>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
smime.p7s
Description: S/MIME Cryptographic Signature
