Have some raw data I get that has mostly numeric data.
The minor issue I have is that some fields in these
numeric columns have a - (dash) rather than a 0 or other
number. After importing data into LibreOffice Calc these
cells are left aligned text fields, where numeric fileds are
right aligned. Wanted to have them centered.
Recall the old lotus and quattro pro use the ' " ^ at the
beginning of text fields to set them up as left right
centered. But don't think that works in either Excel or
To get what I wanted, ended up highlighting how range
and setting up a conditions format option for cell = "-"
and creating a new style I called Centered with just the
alignment option of center. That works, but seems
overkill for few fields. About 250 rows and 19 columns of
Perhaps I've missed an option or it was just something
the newer spreadsheets just don't support?
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] Formatting Question.. · Michael D. Setzer II
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