What are calc cell width and height measured with?

Is the measurement pixels or imperial inches or metric centimeters / millimeters? I’d like to be able to calculate the size of the occupied space in my sheets so I can make an image a background for the occupied space if I’d want to use something other than a solid color.


Format > Page > Background doesn’t work for some reason. If I go there and, even with the default images available there, if I select one and click nothing happens.

The size and the Position Attributs are in units of 1/100mm

If you click and drag column or row to resize, the size and unit seems to be shown in a tool tip; units can be changed in the configuration Tools | Options | LibreOffice Calc | General under Metrics

Thanks! I looked in the calc options but not the general options.

Perhaps you need to refine your search a little - pica measurement at DuckDuckGo

And a suggestion - spend a little time perusing the multiple things you can configure under Tools | Options; you may be surprised what you’ll find. Doubtless as a former tech support person this would be advice you have often given to others.

I did change my search terms a bit and found a definition that makes sense. Thank you!

A graphic designer, writer, and artist who writes about and teaches print and web design. A pica is a typesetting unit of measurement commonly used for measuring lines of type. One pica equals 12 points, and there are 6 picas to an inch

It is a new term. Graphics, computers, photography and film since the early 80s and I’ve never heard of a pica.

Yes. Many times I’ve suggested someone does something in options. There’s a lot of options to surf through. Unless something’s weird or not working I don’t mess with them. New calc documents are opening with the grid lines (dots everywhere) showing. I’ve looked in options but can’t find why it’s doing that. Where’s that setting at? I’ve been turning it off every time I open a new book through the View menu.

Edit: I found the grid line setting. Thank you!

@karolus, BTW
I would prefer 0.01 mm or 10 µm.
Of course you aren’t expected to mean 1/100mm as 1/(100 mm), but -strictly speaking- the format is ambiguous if not there is a generally accepted specification.
What I would assume to be the “general” way to read an item of the kind 1/measurement is measurement-1 where measurement includes the unit (hopefully SI).
Concerning an oscillator running at a frequency of 10 kHz, e.g, 1/10 kHz would mean the period of 100 µs.
You surely know the kind of quantity named repetency. The reciprocal of a wavelength of 10 µm would be a repetency of 1.0E2 mm-1.

1 Like

That depends on the setting doesn’t it? If a user has the units set to imperial inches it would be whatever 1/100mm converts to imperial as which I don’t know off the top of my head. mm is metric.

That’s not UI but API. No “imperial units” there for the purpose, imo. The alternative to SI units for distances (sizes) in some cases is ‘pixel’. Font properties area a special thing.

Interesting to bring waves and frequencies in to this. I can understand why you referenced that because those are the measurements for those subjects but what does that have to do with Calc row and height measurements? I do from programming, modifying, and fixing 2 way and CB radios and frequency scanners etc as well as my experience with music and audio but I don’t think everyone in the world knows and understands all that. If you mean you’d like it introduced to calc IMO I think it would confuse people beyond confused. Some people have difficulty understanding metric and imperial systems at the same time. Add another one? lol…

Pixels, I think - could be wrong, were created as a way to measure dots on a screen because they can’t be represented as grain is measured on film as people were used to before screens existed. Then pixels were used for graphics, not just fonts you probably know, Lupp, for the longest time. And now we have these pica things. I’m getting to old.

My comment was addressed to “karolus” and labelled “BTW”. I didn’t expect you to be interested.
Anyway: Measuring and the concepts and conventions concerning the coummunication and handling of measurements shouldn’t be re-defined for every specific field of application. Well knowing that my interjection would be ignored if not plausibly exemplified, I took an example from a neighbouring field Simply ihgnore this, too.

I must leave it to whomever to apply outdated concepts in science and technology. I personally surely judge it to be a bad idea.
Concerning the relation between measurements in pixels and in SI, the LibO API has LibreOffice: DeviceInfo Struct Reference.
You may find related flaws due to the outdated concepts forced upon the field of … by a backward looking civilization.
I wouldn’t introduce measurements in verst…

Ok I should write units of (1/100)mm, … thats ok for you?

The admin of this site really need to apply common rules and community guidelines. I guess people are ignoring them since the link to them doesn’t work. Shame. Found the mute button! I wish yall wouldn’t carry on like this in my questions…do it somewhere else. And; fight nicely, children!

Sure, I’m not smart enough to understand, but if you don’t like the site or the people here, why you insist on getting that people doing your project.
Are you going to share the project’s authoring with them?
Are they expending their time for you, to receive such attitude?
Forgive me, but maybe a bit of humility and much more work on learning, could really help you.

2 Likes