Bug 149095 - Line height not accessible in CELL()/CELLULE()
Summary: Line height not accessible in CELL()/CELLULE()
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-05-15 09:59 UTC by regis.coutant
Modified: 2022-05-18 21:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description regis.coutant 2022-05-15 09:59:14 UTC 
Hi,

I would like to have the Line height param accessible from the CELL/CELLULE function.

Or at least I would like to have an option in Calc to take into account OR NOT the
lines/colums that are hidden for formulae/function calculation.

Kind regards.

I have this pb on both platforms MAC OSX 12.3 and win10.
Comment 1 m_a_riosv 2022-05-17 10:24:22 UTC 
There are a couple of functions that can take care of hidden/unhidden cells.
Like AGGREGATE(https://help.libreoffice.org/latest/en-US/text/scalc/01/func_aggregate.html?DbPAR=CALC#bm_id126123001625791), SUBTOTAL(https://help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633)
Comment 2 m_a_riosv 2022-05-18 21:12:59 UTC 
>Thk you very much. Indeed it works at least with (my) new version 7,2,6
>and I so got to know the AGGREGATE function that BTW I wasnt aware of; quite >powerful.
>
>so thx a lot
>
>KR

Pls don't send private messages, add your comments here.

Closed, if you are not agree, please reopen it.