Ask Your Question

what are formula groups in Calc?

asked 2018-11-06 01:26:44 +0200

catbill gravatar image

File > Properties > Statistics displays "formula groups." What are they?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-11-06 02:44:45 +0200

DrewJensen gravatar image

updated 2018-11-06 02:46:07 +0200

A formula group is a continuous range in a column that contains the same token sequence. For instance if cells B1 through B3 each contain a formula of =A1 + 3 through =A3 + 3, that would be one formula group.

The document property is the total of all such ranges found on all sheets.

edit flag offensive delete link more


Thank you. Any thoughts about why it would be helpful to know how many formula groups in a spreadsheet?

catbill gravatar imagecatbill ( 2018-11-06 03:58:19 +0200 )edit

A thought? Yes, Knowledge? No. The thought that's probably wrong:
Technically the formula for a range of (say) 1000 cells only needs to be saved once together with a bit of information about the range (5 integer numbers in the way a RangeAddress is treated by the API). It's like you do it: Enter the formula once and expand the range to apply it as needed.
However, the OpenDocument specifications for .ods don't use this way to efficiency.
Why? Donno! @DrewJensen might know?

Lupp gravatar imageLupp ( 2018-11-06 10:46:08 +0200 )edit

Honestly - I didn't know the property existed on the Statistics page of the Property dialog till reading your question here.

So - at the moment the best I can offer is a reference to this property during a presentation at the 2015 LibreOffice conference. "Improved Automated Error Checking (pg 12)"

Also asked a few other people this same question, just this morning - will let you know what I hear

DrewJensen gravatar imageDrewJensen ( 2018-11-06 18:21:38 +0200 )edit

@Lupp "might know" what? Why the ODF spec ended up the way it did? No.

DrewJensen gravatar imageDrewJensen ( 2018-11-06 18:25:08 +0200 )edit

Drew, I respect your ability to find such a reference. It seems like a round-about way to find out about user error.

catbill gravatar imagecatbill ( 2018-11-06 21:28:06 +0200 )edit

Computation of formula groups can be parallelized more efficiently since LibreOffice 6.4: commit "Thread a group of formula-groups together if possible"

Janus Troelsen gravatar imageJanus Troelsen ( 2020-02-24 18:25:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-06 01:26:44 +0200

Seen: 107 times

Last updated: Nov 06 '18