Printing Named Ranges not functioning L O Calc 28.8.2

Teaman · November 4, 2024, 1:19am

Collecting data monthly, so have 12 identical sheets. Each sheet has a data table and chart.
Want to print either data or chart of any month from wherever I am sheet-wise.

Used Sheet>Named Range and Expressions, Defined for each item per sheet as global per manual. As per manual, selected required item via Format>Print Ranges, Edit. Result is range on the active sheet is chosen, not the selected one.

Set Scope from Global to Sheet name. Format>Print Ranges, Edit. None listed.

So a bit of a charlie foxtrot. Any remedies ?

mariosv · November 4, 2024, 12:54pm

Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.

Teaman · November 4, 2024, 9:55pm

Hello Mariosv

Can’t find the page/copy icon you’ve mentioned, so attached to this email.

BP Readings 2024 Copy.ods (62.7 KB)

Seems the print range does not reference to the sheet name when non-global scope is used (referencing soley to the sheet).

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-CA (en_GB); UI: en-GB
Calc: CL threaded

mariosv · November 5, 2024, 10:13pm

Reproducible Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 665dce4442e48b133b9fe1a2eb792ed3ef81d90c CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

But I’m not sure if it is a bug with named ranges, or Calc doesn’t allow print ranges from a different sheet. In fact, you can a select a range from other sheet, but the sheet is not put in the defined range.

Teaman · November 6, 2024, 12:14am

I agree, it may not be a bug. To me it’s more of an omission. No reference to sheet name means the identical range on the active sheet is chosen, no matter what is chosen in Format>Print Ranges>Edit. Rather think multiple sheet named ranges has not been considered, only single sheet named ranges, which could be considered a hole in the printing of named ranges scenario.

As an aside, which sort of adds to it, would’ve thought it would be more logical to facilitate named range printing from File> Print (options), rather than Format>Print Ranges>Edit.

mikekaganski · November 6, 2024, 4:41am

Format → Print Ranges are for current sheet, can’t be used for managing non-current ones. Edit Print Ranges dialog could get a name improvement to suggest that.
The dialog’s drop-downs must only list current sheet’s ranges, no matter if global or sheet-local. The latter category is relatively new, and not all places are sufficiently adapted for them.

This is a bug.