Ask Your Question

LibreOffice 7.1 Export png/jpg only valid for first (left) sheet?

asked 2021-05-03 13:22:16 +0200

thurston gravatar image

Hello, If my document is a single sheet and if i try to export a sheet in png or jpg, fine. If the document gets two sheets, i cannot manage to export the 2nd sheet in jpg or png. Other said, the export, per default will only consider the first (id:0) left sheet. Is it normal? Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-05-03 14:48:44 +0200

erAck gravatar image

With the second sheet being the active sheet, in the export dialog activate the Selection checkbox. Same for a selected cell range.

edit flag offensive delete link more



God-damn, stupid i am. I didn't see this box. Many thanks! (i created a macro for exporting selection of cells in a png. Just adding this in the code made the trick, based on the solution above:

dim propFich(1) As New
    propFich(0).Name = "FilterName"
    propFich(0).Value = "calc_png_Export"
    propFich(1).Name = "SelectionOnly"
    propFich(1).Value = TRUE
    adresseDoc = convertToURL(imagefilepath) ' place here a valid path
    thiscomponent.storeToURL(adresseDoc, propFich())
thurston gravatar imagethurston ( 2021-05-03 17:40:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-05-03 13:22:16 +0200

Seen: 20 times

Last updated: May 03