At 19:52 05/02/2014 +0000, David Lynch wrote:
I have spreadsheets where the width of the cell borders varies and
is important. I have about twenty different styles which I apply, by
formula (STYLE()), to several hundred cells. The cells are square.
There are two widths of border 0.05pt and 2.05 pt. All is well when
the magnification is 100%: both wide and narrow vertical bars look
the same as the horizontal ones. However, if the magnification
changes the vertical and horizontal bars diverge in appearance.
Sometimes the wide vertical ones look the same as the narrow horizontal ones.
The border widths are expressed in absolute terms, of course, with no
recognition of the resolution of any output format. But when you view
the result, whether it is on display or a printout, possible line
widths are dictated by the actual resolution of those devices. If
you can see the difference between your line widths at 100%, you
should be able to see it at any higher magnification, but if you zoom
out to a lower magnification you will inevitable reach a point when
any difference becomes incapable of being represented and therefore
invisible. This will be different for different devices, of course,
so you may be able to discern on printed output what you cannot see
on your display.
Is there anything I can do to retain consistency of appearance when
Yes. Choose from:
o Don't use small magnifications.
o Use a higher resolution display.
o Select more contrasting border widths.
o Use an alternative technique for distinguishing your cells, e.g.
I trust this helps.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
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