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.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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