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


Þann mán 21.maí 2012 09:05, skrifaði Markus Mohrhard:
Hey,

2012/5/21 Sveinn í Felli <sveinki@nett.is>:


One question:
How do the data-bars interact with cell padding and/or
character height?
Accessed via 'Format/Cells...-->Borders/Spacing to contents'
and/or font size.


They don't. Data bars are a special for of cell background and are
drawn like that. The only feature there that is not related to data
bars is that you can with an option force the data bars without cell
values. See the attached screenshot.
Except for that data bars are behaving exactly like normal cell background.


I see that Jean-Francois Nifenecker had the same kind of
questions concerning formatting of data-bars.
So, since they're kind of a background formatting feature,
and if the user wants to have control over spacing between
the bars and bar height versus data characters; the user
would have to separate the lines with empty extra lines in
between and display the data (if necessary) by repeating the
data in another column.

Sure, this can work as a first introduction of data-bars
(until further development), but I think it is a bit clumsy.

I think it would be better to let either font height or
'Spacing to contents' along with row height control the
data-bars (making them a part of content instead of
background); further on there should be more precise
formatting controls, even some options to display the data
inside respective data-bars (see attached png's) or to
control the distance between data and data-bars.

But beware, this is written without having a clue about how
this can be programmed ;-)

Attachment: databar_data_in_bars.png
Description: PNG image

Attachment: databar_cellpadding.png
Description: PNG image


Context


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.