Change capitalization

Post Reply
lgsl
Posts: 347
Joined: Wed Mar 04, 2020 8:00 pm

Change capitalization

Post by lgsl »

I have a spreadsheet that have several cells with text in lowercase. I need to change it change the capitalization of such rows. There is no option in the ribbon (by default) or the classical menu to achieve this. I did noticed, however, that is possible to add the capitalization commands into the ribbon, the problem is that they do not work. According to the manual, Shift+F3 should allow me to change from lowercase to uppercase, but doesn't work either.

Using PROPER (what I need), UPPER and LOWER, works, but I can't just simply go and manually add =PROPPER("string") to every cell. Is not practical.

I do not know if the capitalization commands not working this is a bug or if this commands shouldn't be available on the customize ribbon interface. However Shift+F3 not working, as the manual appendix states one can use to switch between lowercase and uppercase points to a problem here. Switching the type of the cell from default to text does not help either.

Furthermore: An option to change capitalization between lowercase, uppercase and first letter of each word is a feature already available in every other spreadsheet application I have come across. If this functionality is not available, then I would like to request for it to be added in the near future.
lgsl
Posts: 347
Joined: Wed Mar 04, 2020 8:00 pm

Re: Change capitalization

Post by lgsl »

Why are you going about LibreOffice Calc? It has nothing to do with it. I was quite clear: PlanMaker lacks the functionality to change capitalization despite the manual mentioning it in the appendix and the tool to customize the ribbon allowing me to add the buttons/commands to change it.

I know LibreOffice provides tools to do what I'm asking for. That's not the point. The point is PlanMaker currently can't unless you use the formulas: PROPER, UPPER and LOWER, and in my use case that solution is impractical.
pippobruco
Posts: 3
Joined: Thu Jan 29, 2026 2:46 pm

Re: Change capitalization

Post by pippobruco »

You need to double-click the cell; the Shift + F3 combination works when the cell is in edit mode (with a blinking cursor). Unfortunately, one cell at a time.
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 4154
Joined: Wed Mar 11, 2020 5:31 pm

Re: Change capitalization

Post by SuperTech »

Thank you for the detailed report.

At present, the change-case function works only on text selected while you are editing a cell: double-click the cell (or press F2), select the text, then press Shift+F3. It cannot be applied to whole cells or to a range of selected cells, which is also why the commands added to the ribbon have no effect outside edit mode.

I have forwarded your improvement suggestion.
lgsl
Posts: 347
Joined: Wed Mar 04, 2020 8:00 pm

Re: Change capitalization

Post by lgsl »

SuperTech wrote: Tue Nov 17, 2026 10:10 pm At present, the change-case function works only on text selected while you are editing a cell: double-click the cell (or press F2), select the text, then press Shift+F3. It cannot be applied to whole cells or to a range of selected cells, which is also why the commands added to the ribbon have no effect outside edit mode.
Good to know, but just as with PROPER, UPPER and LOWER when you have hundreds of cells, having to edit each one this way is too tedious. For now I will haveto stick to LibreOffice Calc for this cases.
Post Reply

Return to “PlanMaker for Linux”