Bug 87750

Summary:	make page style choosable from right click on status bar
Product:	LibreOffice	Reporter:	Emil Prpic <smayoo>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	cno, mariosv, philipz85
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
i915 platform:		i915 features:
Bug Depends on:
Bug Blocks:	86066

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 Jay Philips 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!
Cor

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.