[Libreoffice-bugs] [Bug 144924] Split Basic function return Array Type String, not Variant/String like the oldest version

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Oct 5 12:58:56 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=144924

--- Comment #10 from Andreas Heinisch <andreas.heinisch at yahoo.de> ---
Created attachment 175541
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175541&action=edit
Array of Arrays

I think you mean something like this is not possible in the new version. The
macro run in:
Version: 7.0.0.3 (x86)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU-Threads: 6; BS: Windows 10.0 Build 18362; UI-Render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

Sub Main
        Dim sCells
        sCells = "A::B§§B::C§§C::D"
        Dim aaDesMisusOut
        aaDesMisusOut = Split(sCells, "§§") ' aaDesMisusOut
        Dim r
        For r = 0 To UBound(aaDesMisusOut)
                aaDesMisusOut(r) = Split(aaDesMisusOut(r), "::")
        Next

        MsgBox aaDesMisusOut(0)(0)
End Sub

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20211005/bea453b5/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list