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.
Change capitalization
Re: Change capitalization
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.
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
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.
Re: Change capitalization
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.
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.
