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.

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

Best regards,
Carl


Regards,

    Matthias

Thanks,
Carl

@All: Would it make sense to cherry-pick this for AOO41X?

Regards,

     Matthias



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Reply via email to