1949256fc0
add RANK to the list of supported functions
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1299337 13f79535-47bb-0310-9956-ffa450edef68
2012-03-11 07:18:11 +00:00
c20420591c
bugzilla 52057 - updated formula test framework to be aware of recently added Functions
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1294595 13f79535-47bb-0310-9956-ffa450edef68
2012-02-28 11:53:25 +00:00
d1d0ea3692
polished code to register new function impls in runtime
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1293851 13f79535-47bb-0310-9956-ffa450edef68
2012-02-26 15:22:43 +00:00
c8f9bde8ee
removed svn:executable bit from project files
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1212745 13f79535-47bb-0310-9956-ffa450edef68
2011-12-10 08:02:08 +00:00
c46ea351f6
Bugzilla 51961: support compression of temp files in SXSSF
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1212330 13f79535-47bb-0310-9956-ffa450edef68
2011-12-09 11:04:22 +00:00
1df261a03c
Fix bug #51681 - doc example bug
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1179895 13f79535-47bb-0310-9956-ffa450edef68
2011-10-06 23:14:09 +00:00
30e932591b
mention ConditionalFormats, ToHtml and ToCSV in the docs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1152110 13f79535-47bb-0310-9956-ffa450edef68
2011-07-29 05:37:06 +00:00
3e56ba2b90
support for conditional formatting in XSSF including docs and examples
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1152099 13f79535-47bb-0310-9956-ffa450edef68
2011-07-29 04:47:25 +00:00
fcb9fce801
misc fixes in site docs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1141906 13f79535-47bb-0310-9956-ffa450edef68
2011-07-01 11:43:06 +00:00
19a6ad2abd
Bug 51422 - Support using RecalcIdRecord to trigger a full formula recalculation on load
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1140210 13f79535-47bb-0310-9956-ffa450edef68
2011-06-27 15:40:48 +00:00
abe5618b5d
Bug 51415 - Fixed Workbook.createSheet(sheetName) to truncate names longer than 31 characters
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1138819 13f79535-47bb-0310-9956-ffa450edef68
2011-06-23 10:49:11 +00:00
b97e745739
misc fixed in site's quick guide
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1138464 13f79535-47bb-0310-9956-ffa450edef68
2011-06-22 13:48:17 +00:00
8bca63ee94
updated web site docs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1137139 13f79535-47bb-0310-9956-ffa450edef68
2011-06-18 08:39:39 +00:00
7e73b04df6
added an example on conditional formatting in the site's quick guide
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1135656 13f79535-47bb-0310-9956-ffa450edef68
2011-06-14 15:49:17 +00:00
e662460614
fixed a typo
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1133821 13f79535-47bb-0310-9956-ffa450edef68
2011-06-09 12:22:39 +00:00
f21ff28e93
continue SXSSF docs updates and polishing
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1133782 13f79535-47bb-0310-9956-ffa450edef68
2011-06-09 10:38:31 +00:00
93c599be72
SXSSF documentation and polishing
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1133372 13f79535-47bb-0310-9956-ffa450edef68
2011-06-08 12:38:07 +00:00
5f671bd806
As Java doesn't allow static methods on interfaces, allow HSSFFormulaEvaluator or XSSFFormulaEvaluator to generically recalculate all formulas in a workbook
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1101033 13f79535-47bb-0310-9956-ffa450edef68
2011-05-09 14:04:21 +00:00
be805e00a7
Update the HSSF/XSSF comments documentation to include some more steps that are needed to have the comments always show up properly
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1073780 13f79535-47bb-0310-9956-ffa450edef68
2011-02-23 15:27:38 +00:00
712b7463a7
initial import of ExcelAnt tasks, see Bugzilla 50610
...
git-svn-id: https://svn.apache.org/repos/asf/poi/branches/excelant@1072119 13f79535-47bb-0310-9956-ffa450edef68
2011-02-18 20:04:50 +00:00
8ba44207e6
User Defined Function Documentation/Example, see Bugzilla 50587
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1060724 13f79535-47bb-0310-9956-ffa450edef68
2011-01-19 09:22:24 +00:00
13920dccd6
use cached formula result when autosizing sheet columns, see Bugzilla 50211
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1033005 13f79535-47bb-0310-9956-ffa450edef68
2010-11-09 15:04:55 +00:00
75656c36d9
initial support for excel auto-filters
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@983382 13f79535-47bb-0310-9956-ffa450edef68
2010-08-08 11:11:38 +00:00
71048002e4
Update the contributor guidelines (microsoft docs, smaller patches are better etc), and ensure we only have the one copy in /guidelines.html
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@960038 13f79535-47bb-0310-9956-ffa450edef68
2010-07-02 15:51:48 +00:00
b5ccd57cd6
Tweak the iterator section to avoid casts as we have generics, and then ditch the hssf duplicate bit (everyone should be pointed at the ss.usermodel version)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@898750 13f79535-47bb-0310-9956-ffa450edef68
2010-01-13 13:46:36 +00:00
11b696550c
improved work with cell comments in XSSF, also added support for cell comments to SS interfaces
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@884918 13f79535-47bb-0310-9956-ffa450edef68
2009-11-27 17:39:17 +00:00
250b9828d3
Update link to dev.HSSF.java
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@829759 13f79535-47bb-0310-9956-ffa450edef68
2009-10-26 12:09:02 +00:00
5e240d7032
deleted 'svn:executable' property
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@826045 13f79535-47bb-0310-9956-ffa450edef68
2009-10-16 19:17:12 +00:00
31161f94db
removed temporary fix for compatibility with Mac Excel 2008 Sp2
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@802539 13f79535-47bb-0310-9956-ffa450edef68
2009-08-09 13:08:59 +00:00
4926b8c44a
Add a note to the hssf/xssf pages on memory of usermodel vs eventusermodel, and hssf vs xssf
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@800388 13f79535-47bb-0310-9956-ffa450edef68
2009-08-03 14:02:33 +00:00
1a8eda0027
small improvements to r799264
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@799268 13f79535-47bb-0310-9956-ffa450edef68
2009-07-30 13:54:02 +00:00
54b958b1a9
added a note on Compatibility of POI-generated .xlsx files with MS Office 2008 for Mac SP2
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@799264 13f79535-47bb-0310-9956-ffa450edef68
2009-07-30 13:49:25 +00:00
0f1f7d1d48
fixed compatibility issues with OpenOffice 3.0 and Excel 2008 Mac sp2, see Bugzilla #46419 and #47559
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@797350 13f79535-47bb-0310-9956-ffa450edef68
2009-07-24 07:29:22 +00:00
bf76476b0e
updated docs on extraction of embedded objects, misc changes in HSSF
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@795394 13f79535-47bb-0310-9956-ffa450edef68
2009-07-18 16:49:56 +00:00
4551216c2a
added a section on Data Validation to the quick guide, the patch provided by Mark Beardsley
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@784852 13f79535-47bb-0310-9956-ffa450edef68
2009-06-15 16:35:13 +00:00
a9dc8172d7
Fix more XLS2CSV links
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@770693 13f79535-47bb-0310-9956-ffa450edef68
2009-05-01 14:39:04 +00:00
a8217984b6
Fix the XLS2CSVmra link
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@768952 13f79535-47bb-0310-9956-ffa450edef68
2009-04-27 12:36:23 +00:00
ef4b2ebc2e
import OpenXML4j codebase
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@738842 13f79535-47bb-0310-9956-ffa450edef68
2009-01-29 12:44:31 +00:00
1559edee21
set new version.id=3.5-beta5
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@720160 13f79535-47bb-0310-9956-ffa450edef68
2008-11-24 10:48:25 +00:00
796a0eea4f
renamed Name.setFormula to more descriptive setRefersToFormula, also misc improvements in the site docs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@719547 13f79535-47bb-0310-9956-ffa450edef68
2008-11-21 09:22:07 +00:00
6a8bb2c748
more updates in javadocs and site documentation, also misc improvements in common hssf-xssf interfaces
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@714128 13f79535-47bb-0310-9956-ffa450edef68
2008-11-14 20:29:42 +00:00
acc1ba4585
1. fixed XSSFSheet.groupRow and ungroupRow to operate on 0-based arguments, was 1-based2. repackaged common xssh-hssf examples, created a page in the site for them 3. converted broken non-ascii characters to unicode in TestMetaDataIPI and TestWriteWellKnown
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@713981 13f79535-47bb-0310-9956-ffa450edef68
2008-11-14 11:56:41 +00:00
af7f84c27e
common ss interfaces for drawing, clientacnhor and picture, also some refactoring of common hssf-xssf code
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@713279 13f79535-47bb-0310-9956-ffa450edef68
2008-11-12 07:15:37 +00:00
5a5ab51f2b
docs cleanup and improvements
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@713108 13f79535-47bb-0310-9956-ffa450edef68
2008-11-11 18:57:50 +00:00
aa8ee7d78c
bug# 45973: added factory method for FormulaEvaluator, also fixed unpaired tags in javadocs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@713021 13f79535-47bb-0310-9956-ffa450edef68
2008-11-11 11:43:20 +00:00
8a6625a237
Merged revisions 707953,708242,708252,708260,708262,708286 via svnmerge from
...
https://svn.apache.org/repos/asf/poi/trunk
........
r707953 | josh | 2008-10-26 01:17:06 -0700 (Sun, 26 Oct 2008) | 1 line
Bugzilla 45966 - added implementation for FIND function (patch from Torstein Tauno Svendsen).
........
r708242 | nick | 2008-10-27 10:26:52 -0700 (Mon, 27 Oct 2008) | 1 line
Link typo fix
........
r708252 | nick | 2008-10-27 10:59:39 -0700 (Mon, 27 Oct 2008) | 1 line
Patch from bug #46092 - fix hssf dev utility
........
r708260 | josh | 2008-10-27 11:12:09 -0700 (Mon, 27 Oct 2008) | 1 line
Removed obsolete class
........
r708262 | josh | 2008-10-27 11:16:44 -0700 (Mon, 27 Oct 2008) | 1 line
Bugzilla 46065 - added implementation for VALUE function
........
r708286 | josh | 2008-10-27 12:24:42 -0700 (Mon, 27 Oct 2008) | 1 line
Preparation for fix for bug 46009. (Bug visible on ooxml branch, but this change will expose the problem)
........
git-svn-id: https://svn.apache.org/repos/asf/poi/branches/ooxml@708325 13f79535-47bb-0310-9956-ffa450edef68
2008-10-27 21:30:02 +00:00
0db7da83b7
Fix from bug #45676 - Handle very long cells in the XSSF EventUserModel example
...
git-svn-id: https://svn.apache.org/repos/asf/poi/branches/ooxml@694949 13f79535-47bb-0310-9956-ffa450edef68
2008-09-13 14:00:53 +00:00
f9003912c0
New class org.apache.poi.hssf.record.RecordFormatException, which DDF uses instead of the HSSF version, and the HSSF version inherits from
...
git-svn-id: https://svn.apache.org/repos/asf/poi/branches/ooxml@678374 13f79535-47bb-0310-9956-ffa450edef68
2008-07-21 09:34:08 +00:00
2f1ba9f4b5
Finish region tweaks, and fix up upgrading doc
...
git-svn-id: https://svn.apache.org/repos/asf/poi/branches/ooxml@676213 13f79535-47bb-0310-9956-ffa450edef68
2008-07-12 18:53:47 +00:00
2fe075305a
Fix up a few cases where we were using ss.Region but should be using hssf.Region for backwards compatibility
...
git-svn-id: https://svn.apache.org/repos/asf/poi/branches/ooxml@676211 13f79535-47bb-0310-9956-ffa450edef68
2008-07-12 18:28:59 +00:00
Yegor Kozlov