/[Apache-SVN]
ViewVC logotype

Revision 1855789


Jump to revision: Previous Next
Author: gwoolsey
Date: Mon Mar 18 19:09:11 2019 UTC (5 years, 3 months ago)
Changed paths: 18
Log Message:
#60724 - Partial implementation for SUBTOTAL() 'ignore hidden rows' variations

The function still doesn't deal with auto-filtering, but it now handles variations that should skip hidden rows.

Taught the evaluation framework to know about hidden rows similar to what was already there for skipping subtotals within subtotal ranges.

Added unit test cases.

Changed paths

Path Details
Directorypoi/site/src/documentation/content/xdocs/changes.xml modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/hssf/usermodel/HSSFEvaluationSheet.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/EvaluationSheet.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/LazyAreaEval.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/LazyRefEval.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/SheetRefEvaluator.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/TwoDEval.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/eval/AreaEvalBase.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/eval/forked/ForkedEvaluationSheet.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/functions/AggregateFunction.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/functions/Count.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/functions/Counta.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/functions/MultiOperandNumericFunction.java modified , text changed
Directorypoi/trunk/src/java/org/apache/poi/ss/formula/functions/Subtotal.java modified , text changed
Directorypoi/trunk/src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFEvaluationSheet.java modified , text changed
Directorypoi/trunk/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFEvaluationSheet.java modified , text changed
Directorypoi/trunk/src/testcases/org/apache/poi/ss/formula/functions/TestSubtotal.java modified , text changed
Directorypoi/trunk/test-data/spreadsheet/SubtotalsNested.xls modified , text changed

infrastructure at apache.org
ViewVC Help
Powered by ViewVC 1.1.26