Version: 24.2.5.2 (X86_64).
With a formula in the cell too, the character spacing never seems to stick at all.
All spreadsheet applications align numbers at the right cell margin. If your sequence of digits is really meant to be a decimal number, you can enforce left alignment. If your sequence is meant to be a phone number, zip code, article number or any other kind of identifier, format the cells as text before digits. Text cells have no numeric value. Entered text is taken literally.
Convert existing numbers to text:
- Select cells
- Format as text.
- menu:Edit>Find&Replace…
3.1. Current selection only: Yes
3.2. Regular expression: Yes
3.3. Search:.+
3.4. Replace:&
3.5 [Replace All]
Sorry, I clarified my question. I don’t think your answer has anything to do with what I’m asking.
A formula returning text returns one string. You can not format any substrings of formula results.
1 Like
You are free to report this as a request for enhancement. I would rather remove the formatting of the displayed formula string which raises wrong expectations.
I guess the following was meant for this thread:
1 Like
You should report a feature request, not a bug; and the request must be not to allow formatting selection with formulas, but to enable the sidebar’s Set Character Spacing control when you are not in the cell editing mode (and - what is the same thing - to enable Format → Character in that mode). Because it’s not clear why this formatting can’t apply to the whole cell, which would allow to work fine with formulas.
2 Likes