Hi Czesław and All,
On 8/8/22 12:23 PM, Czesław Wolański wrote:
Hi Carl,
user-defined function "StarBasicTab"
Function StarBasicTab(x As Long) As String
StarBasicTab = Tab(x)
End Function
Calc does not display HT (ASCII 09) in the cell.
Testing:
Cell A2: 1
Cell B2: =StarBasicTab(A2)
cell C2: =REPT(UNICHAR(9);A2)
cell D2: =(B2 = C2)
See the .ods file available at the link
https://drive.google.com/file/d/1oh4yK6IGDdzUGwPPV7fX4J8Xr0SUlTm0/view?usp=sharing
Perfect :)
I should be able to use it just like this.
I confirm it works using a trunk build.
Since this was back in 2015, I think this is another example of us
thinking 4.2 was right around the corner and not back-porting to 4.1.
+1 to back-port it.
Best regards,
Carl
Hope this helps
Czesław
pon., 8 sie 2022 o 17:07 Matthias Seidel <matthias.sei...@hamburg.de>
napisał(a):
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: 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
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
