https://bugs.documentfoundation.org/show_bug.cgi?id=98845
DM <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #4 from DM <[email protected]> --- To explain the top post a bit better - you 1. create a new spreadsheet 2. create a new module 3. ensure the code as below 4. with the insertion point in Main() use F5 to run it. It will fail on Set oColB (but not on Set oCol). Same problem if instead of a New Collection you'd used various other complex items, including arrays. If oCol/oColB are kept as variants and Set omitted the same occurs, but usage of an simple literals (eg a number or string) is fine (eg using o.Add "T",5 is fine). hope that helps! d --------- FAILS ---------- Sub Main Dim o As Object, oCol As Object,oColB As Object Set o=New Scripting.Dictionary o.Add "T", New Collection Set oCol = o.Item("T") Set oColB = o.Item("T") End Sub --------- ALSO FAILS ---------- Sub Main Dim o As Object, oCol,oColB Set o=New Scripting.Dictionary o.Add "T", New Collection oCol = o.Item("T") oColB = o.Item("T") End Sub -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
