Bug 152181

Summary:	Calc Enhancement request: Consistent formatting, page formatting
Product:	LibreOffice	Reporter:	james_d
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WONTFIX
Severity:	enhancement	CC:	stephane.guillou
Priority:	medium
Version:	6.0.2.1 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description james_d 2022-11-23 08:31:44 UTC

Description:
Here's what I'd like to be able to do in Calc:
- Easily edit the page format, specifying things like the default font and its size in an easily accessible "page format" menu within the Format drop-down menu.
- Not having to reset the default type and size each time I cut a value from a cell and paste another one becaue Calc, for some unfathomable reason, cuts out the formatting along with the cell value.

Actual Results:
Not applicable

Expected Results:
Not applicable


Reproducible: Always


User Profile Reset: No

Additional Info:
Not applicable

Comment 1 Stéphane Guillou (stragu) 2022-12-03 22:54:30 UTC

Hi James

I think that Styles do what you are after.
Starting with a new document, you can apply a custom cell style to specific cells, or a page style to the whole sheet. You can find those (and create custom ones) in the Styles menu or the Style sidebar.

When copy-pasting, you can use Paste special > Unformatted text (or its shortcut Ctrl + Alt + Shift + V). It will not bring along the formatting.

In my opinion, the tools are there and this is a "won't fix".