]> source.dussan.org Git - poi.git/commit
projects / poi.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: d7c5977) | 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)
commit6f575305c6b5dd747568a48f72f7c7a5817a5705
tree5102045fbc39c4a89c29a3d231ddca580835e4eetree | snapshot
parentd7c5977a456fc7f514b96c639748ad9bdaf60244commit | 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