[Libreoffice-bugs] [Bug 40115] New: Export as PDF in Calc does not obey the PageRange instruction in a macro

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=40115

           Summary: Export as PDF in Calc does not obey the PageRange
                    instruction in a macro
           Product: LibreOffice
           Version: LibO 3.3.3 release
          Platform: x86 (IA32)
        OS/Version: Linux (All)
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: john.moore.ga at att.net


I need to perform several exports from a Calc spreadsheet each week for several
other departments.  Each requires a different selection of sheets from the
multi-sheet document, and some departments are not allowed to access the data
on those sheets.

If I do the export manually, the export works correctly, but is time-consuming.

If I attempt to do this through a macro, although the PropertyValue:
Array("PageRange",0,"1,3,5,7",com.sun.star.beans.PropertyState.DIRECT_VALUE) 
is used, every sheet in the workbook will be placed into the PDF.

My workaround is to do the job manually :-(

Although that works, I have to check every file to be certain I'm not sending
inappropriate information to the wrong department.  Automation would be a big
improvement.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.