[PLUG] Libre Office Calc merge and center cells broken

[Ben Koenig]

------- Original Message -------
On Tuesday, May 24th, 2022 at 5:00 PM, Dick Steffens <dick at dicksteffens.com> wrote:


> Is anyone else having trouble with merge and center cells in Libre
> Office Calc, Version: 6.4.7.2?
>
> It's worked correctly for years, but recently quite working. On the
> toolbar there is an icon that used to cause the contents of a selected
> group of cells to merge and center. That icon is grayed out. There is an
> option in Format > Cells > Alignment, Text Alignment, Horizontal Center,
>
> Vertical, Middle. But the vertical option only allows "Default". This is
> not a critical issue, but it is annoying.
>
> --
> Regards,
>
> Dick Steffens

I've been running into issues like this recently. I don't know the root cause but I can usually get it to work with some fiddling.

First, the merge option. You cannot merge a "merged" cell. So if for example you have 2 cells that are already merged and you want to add a 3rd, you need to unmerge then merge all 3.

Second, I have definitely encountered what you described for the centering option. I've also run into that for all other formatting options. As best as I can tell, it happens when you have a cell open for editing or some sort of other selection. All formatting options will be disabled based on the context of what you are doing. This can also affect the merging option.

When those buttons are disabled then Calc probably thinks you are editing a cell or something. It's been a source of annoyance for me since I move really fast when setting up a spreadsheet.

-Ben