CountStyle

Tags: Calc Extensions

Rating: ★ ★ ★ ★ ★

Two Calc functions for counting cells or cell content by cell style. Compatible with both Apache OpenOffice and LibreOffice.

countstyle db299ab6 7970 454e 9710 6885b70fd80d

Description

COUNTSTYLE is an extension dedicated to the Calc module.

It is aimed to perform operations based on the cell formatting, such as typically (but not only) the background colour.

COUNTSTYLE example

Instructions

Download the most recent countstyle-x.x.x.oxt file and install it from Tools->Extension Manager.

Restart the program.

Countstyle adds two new functions to Calc, accessible from the function wizard: COUNTSTYLE and CELLSTYLE.

Formulas using these functions are automatically updated when a new style is applied.

Syntax

COUNTSTYLE(range, style [, function])

<range>: the referred cell range
<style>: the style to count (case sensitive)
<function>: an integer giving the operation to compute
    0 or missing argument: number of cells
    1: sum of values
    2: number of non empty cells
    3: average of values
    4: maximal value
    5: minimal value
    6: number of numeric values

CELLSTYLE(cell)

<cell>: the cell from which you want to get the style

Translations

  • fr

COMPTE.STYLE(plage, style [, fonction])

STYLE.CELLULE(cellule)

  • it

CONTA.STILE(area, stile [, funzione])

STILE.CELLA(cella)

  • ja (thanks to nogajun)

COUNTSTYLE(範囲, スタイル [, 機能])

CELLSTYLE(セル)

Tips

As Jeff pointed it out on the french forum, it is also possible to count multiple styles at once:

Count multiple styles at once example

Limitations

By design, COUNTSTYLE only counts cells formatted with the style given as argument. Direct formatting is ignored and colour names are not allowed.
COUNTSTYLE doesn't work with style applied by mean of conditional formatting: not only would this be awkward and unwiedly (there is no easy API method to retrieve such colouring), but also useless, as you just need to count cells on the same condition used for formatting.

Why counting styles rather than colours?

It's far easier for the user to define a style rather that trying to retrieve a colour reference.
And what should this reference be: the colour name?, the decimal value?, the rgb or the hexadecimal representation?

By the way, what colour should COUNTSTYLE count: the background colour?, the characters colour?, the borders one?...

Colour are not the same for everyone, and besides, colour names and values differ between OpenOffice and LibreOffice. For example, OpenOffice "red" is rgb 255,51,51, while one would expect 255,0,0!

With styles you can count coloured cells, but you can also count on any property you want: background or character colour, character weight, cell borders, font, any mix of those and so on...

Homepage: https://gitlab.com/jmzambon/countstyle

Release List

  • Release Description Compatibility Operating Systems License Release notes  
  • 1.1.1 Return error 502 when CELLSTYLE is used with cell range as parameter. 3.3 Linux, Windows, macOS AL external link
  • 1.1 Localisation: JA 3.3 Linux, Windows, macOS AL

    Japanese translation thanks to nogajun.

    external link
  • 1.0 Initial release 3.3 Linux, Windows, macOS AL

    Translations

    fr

    COMPTE.STYLE(plage, style [, fonction])

    STYLE.CELLULE(cellule)

    it

    CONTA.STILE(area, stile [, funzione])

    STILE.CELLA(cella)

     

    external link

Feedback

★ ★ ★ ★ ★

Post your review

Reviews

  • Davin Jul 15, 2020, 11:05 PM (21 hours ago)

    ★ ★ ★ ★ ★

    Nice extension, very useful

RSS feed for reviews on this page | RSS feed for all reviews