Created attachment 191615 [details] Originally, the attachment was an excel file that was opened without any errors Selecting contents of column A and increasing their size only changes some of the column contents. Noticed the following: - * Nothing happens if cells A3 to A5 are selected and their fonts changed. Didn't check other cells * Works OK if file is saved as an Excel file
I can confirm the part regarding the ods file. Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 16; OS: Linux 6.6; UI render: default; VCL: kf5 (cairo+xcb) Locale: es-ES (es_ES.UTF-8); UI: es-ES Calc: threaded
Attachment 191615 [details] is an XLT template file. Saving either as ods or as xlsx file formats, and changing the font size of column A "fails" to change the font size to several cells. Note that [CTRL]+[1] > Font (tab), will show the font size that was applied (or at least attempted to). This is not reflected on the main area/cells. Also note that using the "Increase Font Size" icon of the "Formatting" toolbar (part of the Standard toolbar UI) works correctly. The reason for the failure is that each of those cells (that do not change size) contain text that is _partly_ formatted with different attributes. For example, cell A3 contains the text: "1. All timesheets should reflect the app" The initial "1." in that quoted text is formatted as bold whereas the rest of the text within the same cell is not. If you clear the format of the cells (e.g. select the range of cells and then "clear format", [CTRL]+[M] with English shortcuts), then the font size can be changed as usual. Alternatively, you have to enter to cell's edit mode, select the text within each cell, and modify the font's size (cell by cell). IMHO, applying a new format (e.g. font size) to all the range of selected cells should rather be allowed for such cases anyway. I do not know whether the "failure" is a bug or intentional (as there are pros and cons). I also don't know whether this should be considered as an enhancement request.
Thank you all. I understand this issue to be the same as bug 39969. Marking as duplicate. Regarding the sample attached here, note some differences depending on what is selected. Change font size on: - column A: partial - cell A3: works - row 3: works, but everything is bold - A3:A4: works, but everything is bold - A3:A5: does not work (discrepancy also noted in bug 90781 comment 13) *** This bug has been marked as a duplicate of bug 39969 ***