Bug 87750 - make page style choosable from right click on status bar
Summary: make page style choosable from right click on status bar
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Statusbar
  Show dependency treegraph
Reported: 2014-12-26 17:06 UTC by Emil Prpic
Modified: 2024-05-04 12:19 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Emil Prpic 2014-12-26 17:06:34 UTC
When I open any document (ODS or XLS or XLSX), I should be able to change the page style for any worksheet by right-clicking on the chosen style name written in the status bar (on the bottom of the window), then a list of styles should appear and left-clicking a style from the list chooses that style for that worksheet. I'm sure this worked before, or maybe it works on Linux.
However, now right-clicking the style name in status bar has no effect. To change the style of a worksheet I need to open the Sytles and Formatting, click the tab with page styles, click the style I want to change to, then select the Fill Format tool, and then click anywhere on a spreadsheet I want to change.
Comment 1 m_a_riosv 2014-12-26 20:48:36 UTC
Hi Emil, thanks for reporting.

I have just verified it doesn't work with any version of LibreOffice from 3.3 up 4.4, neither with ApacheOpenOffice 4.1.

I you like change the importance from minor to enhancement.
Comment 2 Emil Prpic 2014-12-27 09:33:52 UTC
OK. But I am 100% *CERTAIN* that it worked that way before. Maybe it was Apache OpenOffice 3.x. Not only that. I distinctly remember reading an instruction that this is the way to change the page style and was annoyed that it didn't work (any more).
Comment 3 m_a_riosv 2014-12-27 12:09:31 UTC
Then please change title for one asking for the enhancement.

Maybe could help assigning a shortcut for a style.
Comment 4 Emil Prpic 2014-12-27 13:10:30 UTC
Not possible. When you open an xls, you have as many page styles, as there are worksheets, and each is named after its worksheet (i.e. differently every time).
Comment 5 Yousuf Philips (jay) (retired) 2014-12-27 13:53:08 UTC
This feature is available in writer, so it would be great to also have it in calc, as you are only able to do this through the styles & formatting dialog in calc. I tested AOO 3.3 (the first version released by Apache) and its not present there, so maybe it was a release by Sun.
Comment 6 Cor Nouws 2014-12-27 19:46:22 UTC
(In reply to Emil Prpic from comment #2)
> OK. But I am 100% *CERTAIN* that it worked that way before.

In Writer yes - and still. But in Calc I've never seen it work (started in 2004, but that doesn't say all of course).

Still: thanks for the issue and request!
Comment 7 m_a_riosv 2023-05-17 17:13:22 UTC
Still pending.
Version: (X86_64) / LibreOffice Community
Build ID: 22950a9b008e1bb22fa9e54b5d45715e25fee764
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 8 m_a_riosv 2023-12-05 01:16:23 UTC Comment hidden (obsolete)
Comment 9 V Stuart Foote 2024-05-04 12:19:30 UTC
see discussion see also bug 160920