Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

At 12:04 04/09/2018 -0400, Charles Meyer wrote:
Excel seems to have a built-in flaw ...

I'm not sure we discuss other providers' products here!

... where if one cell gets too close to another cell ...

All cells in a spreadsheet abut all surrounding cells. There is never any question about how close they are: they are always completely close.

Ex.  In an Excel cell …  The cell is getting too close


Shall we talk about Calc? The only way this sort of thing could happen, I think, is if the text in the cell actually contains trailing spaces and that the cell formatting is set to "Wrap text automatically".

Is there anyway to delete/remove/eliminate that extra space under characters in a cell in Libre Calc?

o Delete those rogue space characters (if you don't need them), or
o Change the font size, or
o Expand the column width appropriately.
o Merge cells appropriately.

Also, Excel does not allow you to change the case size after you've saved the file.

I don't believe that - but we are not talking about Excel; remember?

In Word, you can toggle among small case – initial caps - all caps easily – but not in Excel.

Er, we are not talking about Word, either!

Can you toggle among case sizes in Libre Calc?

Not that I know of. But you could easily copy material into a text (Writer) document, modify it there, and copy it back. If you use Paste Special... and paste it into the text document as HTML you should see a table. That way, you can handle arbitrary ranges in one go, not just individual cells.

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.