]> source.dussan.org Git - poi.git/commit
projects / poi.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 19005a4) | patch
#60724 - Partial implementation for SUBTOTAL() 'ignore hidden rows' variations
authorGreg Woolsey <gwoolsey@apache.org>
Mon, 18 Mar 2019 19:09:11 +0000 (19:09 +0000)
committerGreg Woolsey <gwoolsey@apache.org>
Mon, 18 Mar 2019 19:09:11 +0000 (19:09 +0000)
commit82f9c292589bc9dd84c4b9b699129cc191513a03
tree5102045fbc39c4a89c29a3d231ddca580835e4eetree | snapshot
parent19005a4e63b6855c6cb889ba546781cb43fc22f5commit | diff
#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.

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1855789 13f79535-47bb-0310-9956-ffa450edef68
17 files changed:
src/java/org/apache/poi/hssf/usermodel/HSSFEvaluationSheet.java diff | blob | history
src/java/org/apache/poi/ss/formula/EvaluationSheet.java diff | blob | history
src/java/org/apache/poi/ss/formula/LazyAreaEval.java diff | blob | history
src/java/org/apache/poi/ss/formula/LazyRefEval.java diff | blob | history
src/java/org/apache/poi/ss/formula/SheetRefEvaluator.java diff | blob | history
src/java/org/apache/poi/ss/formula/TwoDEval.java diff | blob | history
src/java/org/apache/poi/ss/formula/eval/AreaEvalBase.java diff | blob | history
src/java/org/apache/poi/ss/formula/eval/forked/ForkedEvaluationSheet.java diff | blob | history
src/java/org/apache/poi/ss/formula/functions/AggregateFunction.java diff | blob | history
src/java/org/apache/poi/ss/formula/functions/Count.java diff | blob | history
src/java/org/apache/poi/ss/formula/functions/Counta.java diff | blob | history
src/java/org/apache/poi/ss/formula/functions/MultiOperandNumericFunction.java diff | blob | history
src/java/org/apache/poi/ss/formula/functions/Subtotal.java diff | blob | history
src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFEvaluationSheet.java diff | blob | history
src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFEvaluationSheet.java diff | blob | history
src/testcases/org/apache/poi/ss/formula/functions/TestSubtotal.java diff | blob | history
test-data/spreadsheet/SubtotalsNested.xls diff | blob | history
Mirror of Apache POI: https://github.com/apache/poi