https://bugs.documentfoundation.org/show_bug.cgi?id=120504
Bug ID: 120504
Summary: VBA Worksheet.PrintOut method prints active sheet, not
the one that calls the method
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 145590
--> https://bugs.documentfoundation.org/attachment.cgi?id=145590&action=edit
A sample spreadsheet with a macro to test Worksheet.PrintOut
In the attached sample spreadsheet, there is a macro:
> Option VBASupport 1
>
> Sub Print_Out()
> Dim sh As Worksheet
> Set sh = Sheets("Sheet2")
> sh.PrintOut
> End Sub
It is expected to print Sheet2, regardless of which sheet is active at the
moment, using Worksheet.PrintOut (see
https://docs.microsoft.com/en-us/office/vba/api/excel.worksheet.printout).
In reality, in LibreOffice it prints active sheet. You may test that by
executing it when in Sheet1. In this case, Sheet1 will be output.
Tested with current master, and with Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 12; OS: Windows 10.0; UI render: GL;
Locale: ru-RU (ru_RU); Calc: CL
and also with OpenOffice.org 3.2.0 OOO320m12 (Build:9483).
--
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
