Description: When formatting a Spreadsheet, ONLY the 'selected' cells get the NEW formatting. All the cells in a spreadsheet should be the NEW Format. If only a few cell should be re-formatted, then selecting them BEFORE the Re-Format should restrict the change to these cells ONLY. Keep up the Good Work, Ciao Actual Results: Entering data in an 'unused' Calc cell, defaults to 10 pt text height! Expected Results: Should be the SAME as the selected test height selected for the Currently Occupied Cells. Reproducible: Always User Profile Reset: No Additional Info: Maintain a CONSISTENT Text Formatting (except of previously SPECIALLY Formatted Cells).
Likely a dupe of bug 153527? But the "ONLY the 'selected' cells get the NEW formatting" confuses me: so are you selecting some part of sheet, and expect other parts be formatted? Or is your issue that you select everything, but only non-empty (not "selected") cells get the formatting?
Created attachment 190418 [details] Comparison
I believe I understand the statement "ONLY the 'selected' cells get the NEW formatting." Let's consider these steps: 1. Open a new Spreadsheet >> Observe that: The first cell - A1 is selected by default. 2. Select the menu Format >> Text >> Bold (or any other options). 3. Type anything in cell A1 >>> Observe that: The text is Bolded. 4. Type anything in other cells >> Observe that: The formatting selected in step #2 is not applied. So, the expectation here might be that "The Bold format" should be applied to all other cells. If so, it will differ slightly from the bug [153527]. Furthermore, I compared this behavior with Microsoft Excel and noticed that we can make it work that way, while Google Sheets does not. Therefore, the decision to be made here is whether we should align with Microsoft Excel or Google Sheets.
NEEDINFO while we wait for the reporter to respond.
Nik: wouldn't it be better to go to Sidebar - Styles, right-click Default - Edit Styles and define your formatting there, so it applies throughout the spreadsheet?
I'll go ahead and close as wontfix.
*** Bug 158153 has been marked as a duplicate of this bug. ***
(In reply to ToanTran from comment #3) > 1. Open a new Spreadsheet >> Observe that: The first cell - A1 is selected > by default. > 2. Select the menu Format >> Text >> Bold (or any other options). > 3. Type anything in cell A1 >>> Observe that: The text is Bolded. > 4. Type anything in other cells >> Observe that: The formatting selected in > step #2 is not applied. > > So, the expectation here might be that "The Bold format" should be applied > to all other cells. If so, it will differ slightly from the bug [153527]. > > Furthermore, I compared this behavior with Microsoft Excel and noticed that > we can make it work that way 1. How can we "make it work that way" in case of Excel? This is important to be able to repro, and to evaluate how useful the feature is (maybe it's some backward-compat option in Excel, that they themselves have deprecated?) 2. It is a possibility to introduce the existing "AutoUpdate style" feature [1], existing in Writer, to Calc's cell styles. Then a direct formatting to a cell could automatically translate into that cell's style update, with immediate effect on the whole file. [1] https://help.libreoffice.org/latest/en-US/text/shared/01/05040100.html?DbPAR=WRITER
(In reply to Mike Kaganski from comment #8) But of course, it all depends how correct ToanTran guessed the meaning of the unclear comment 0. And without clarifying that, the current resolution is the correct one.