[Libreoffice-bugs] [Bug 143186] pivotcaches - BASIC runtime error 423 ---- + other multiple errors

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from johnks <testing1237a-c at yahoo.com> ---
this file contains more code which throws errors so i am going to club them
together otherwise i have to write the same error, upload same file multiple
times. let me know if i am supposed to upload new bugs for each error
separately


second bug is 
ShowPivotTableFieldList- Basic runtine error 423

here is the code which throws basic error.

 ```` ActiveWorkbook.ShowPivotTableFieldList = True ````

it looks like this function isnt enabled or something.
attached screenshot of the error as well




----
third bug is 

"basic runtime error 1

no such elementexception

the offending code is

````ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables
````

and this code 

````ActiveSheet.PivotTables("PivotTable1").AddDataField
ActiveSheet.PivotTables( _ ````


and this code
```` ActiveSheet.PivotTables("PivotTable1").TableStyle2 = "PivotStyleDark4"
````

and this one
 ```` .ThemeColor = xlThemeColorDark1 ````

-- 
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/20210704/a021b656/attachment.htm>