| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3RowVisible"
| (One intermediate revision by one other user not shown) | |||
| Line 26: | Line 26: | ||
For example if many XL3RowVisible formulae are driven by one cell, you must expand this to have one driving cell per row, as seen below. | For example if many XL3RowVisible formulae are driven by one cell, you must expand this to have one driving cell per row, as seen below. | ||
| − | [[File:RowVisibleBefore.PNG|center|thumb|400px|alt=Incorrect usage|All formulae point to a single cell]] | + | [[File:RowVisibleBefore.PNG|center|thumb|400px|alt=Incorrect usage|Incorrect: All formulae point to a single cell.]] |
| − | [[File:RowVisibleAfter.PNG|center|thumb|400px|alt=Correct usage|Formulae point to their own driving cell]] | + | [[File:RowVisibleAfter.PNG|center|thumb|400px|alt=Correct usage|Correct: Formulae point to their own driving cell. Driving cells copy down the master cell.]] |
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
* [[XL3ColumnVisible|XL3ColumnVisible formula]] | * [[XL3ColumnVisible|XL3ColumnVisible formula]] | ||
| + | * [[XL3SheetVisible|XL3SheetVisible formula]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:Report Management Formulae]] | [[Category:Report Management Formulae]] | ||
[[Category:Report Management]] | [[Category:Report Management]] | ||
Latest revision as of 12:50, 29 April 2016
Shows and hides the row the formula is in.
Contents
[hide]Syntax
XL3RowVisible( Visible )
Parameters
| Parameter | Description |
|---|---|
| Visible | If set to TRUE the row is shown; if set to FALSE the row is hidden |
Examples
Hides the row if the value in cell A3 is less than or equal to 10000.
=XL3RowVisible( A3 > 10000 )
Limitations
When published to the web it is necessary for the formula to change in each cell to get correct results.
For example if many XL3RowVisible formulae are driven by one cell, you must expand this to have one driving cell per row, as seen below.
