Apache\POI.jar is there any option to enable data/column filters using poi.jar.
i am crearting excel sheet using POI.jar,user wants to enable data filter along with the excel generation.Is there any such kind of option like showing auto filters. Thans in advance -- View this message in context: http://www.nabble.com/Apache%5CPOI.jar-is-there-any-option-to-enable-data-column-filters-using-poi.jar.-tp21067625p21067625.html Sent from the POI - Dev mailing list archive at Nabble.com. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 30302] cell.getDateCellValue() returns 10:59:59 instead of 11:00:00
https://issues.apache.org/bugzilla/show_bug.cgi?id=30302 Toni Helenius changed: What|Removed |Added Attachment #23034|0 |1 is obsolete|| --- Comment #5 from Toni Helenius 2008-12-17 13:21:51 PST --- Created an attachment (id=23035) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23035) XLS where POI reads dates incorrectly (repack) -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46308] XWPFTable - basic support for table
https://issues.apache.org/bugzilla/show_bug.cgi?id=46308 Yegor Kozlov changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #1 from Yegor Kozlov 2008-12-17 12:07:52 PST --- Applied in r727498 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=727498 ) Yegor -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46300] XWPFParagraph - improvement
https://issues.apache.org/bugzilla/show_bug.cgi?id=46300 Yegor Kozlov changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #1 from Yegor Kozlov 2008-12-17 12:07:46 PST --- Applied in r727498 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=727498 ) Yegor -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46299] XWPFRun: carriage return and break line
https://issues.apache.org/bugzilla/show_bug.cgi?id=46299 Yegor Kozlov changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #1 from Yegor Kozlov 2008-12-17 12:07:42 PST --- Applied in r727498 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=727498 ) Yegor -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 30302] cell.getDateCellValue() returns 10:59:59 instead of 11:00:00
https://issues.apache.org/bugzilla/show_bug.cgi?id=30302 --- Comment #4 from Yegor Kozlov 2008-12-17 11:37:04 PST --- I can't unzip the attached file. Please re-attach. Yegor -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
Re: HDGF, chunks_parse_cmds.tbl, and GPLv3
Hi Nick, BTW - It looks like http://www.apache.org/legal/resolved.html has been substantially updated recently (in the past few months) and it is clear there that the GPL and LGPL must not be included. There do not appear to be any exceptions for "data." Yup, that's what we'll need to talk about on legal-discuss, assuming that the vsdump project doesn't dual license the file in question (which I'm hoping they will do, should hear more on the weekend) Has vsdump provided a compatible license? Are we satisfied? If not, then it is time to remove the code. If you later get an appropriate license then we should vote to bring it back. After all, isn't this code a bit like a very mini version of the ooxml4j donation? If the release for 3.5b4 was incorrect because of this then how should we proceed? I think as long as we resolve it one way or another before the next release, learn our lesson, and cover it in the next board report we ought to be ok :) I suppose. Regards, Dave Nick - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 30302] cell.getDateCellValue() returns 10:59:59 instead of 11:00:00
https://issues.apache.org/bugzilla/show_bug.cgi?id=30302 Toni Helenius changed: What|Removed |Added CC||toni.helen...@lut.fi --- Comment #3 from Toni Helenius 2008-12-17 06:06:03 PST --- I can confirm this bug. I attached a test XLS for you guys so you can hurry up the fixing. No need for extra 4 years anymore! :) -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 30302] cell.getDateCellValue() returns 10:59:59 instead of 11:00:00
https://issues.apache.org/bugzilla/show_bug.cgi?id=30302 --- Comment #2 from Toni Helenius 2008-12-17 06:05:10 PST --- Created an attachment (id=23034) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23034) XLS where POI reads dates incorrectly cell.getDateCellValue() returns xx:59:59 instead of xx:00:00. Not on every row, rather randomly... -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46411] New: Formatting of Excel date values < 1.0 show different date to Excel
https://issues.apache.org/bugzilla/show_bug.cgi?id=46411 Summary: Formatting of Excel date values < 1.0 show different date to Excel Product: POI Version: 3.5-dev Platform: PC OS/Version: Windows XP Status: NEW Severity: minor Priority: P2 Component: HSSF AssignedTo: dev@poi.apache.org ReportedBy: sebut...@gmail.com In Excel 2003, when a TIME(h,m,s) value is formatted as a date, or includes a date component. For example, when TIME(12,0,0) is formatted with the format string "-mm-dd hh:mm:ss", the date is shown as 1900-01-00 12:00:00 in Excel. This is obviously not a correct date but it is what Excel does with the value. POI formats the value as 1899-12-31 12:00:00 which is a valid date, but not the same as the value produced by Excel. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46410] New: [PATCH] Implementation of Excel TIME(h,m,s) function
https://issues.apache.org/bugzilla/show_bug.cgi?id=46410 Summary: [PATCH] Implementation of Excel TIME(h,m,s) function Product: POI Version: 3.5-dev Platform: PC OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: dev@poi.apache.org ReportedBy: sebut...@gmail.com Created an attachment (id=23033) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23033) Patch to implement TIME() Formula - includes new unit test file TestTime.java I have tried to implement the Excel TIME() function in the attached patch. Note that I had to include a precision parameter in the unit tests for the numeric comparisons in the unit tests because Excel seems to have higher internal precision than it is willing to display. For this reason the unit tests also test the formatted time against the expected values as a secondary test. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[g...@vmgump]: Project poi (in module poi) failed
To whom it may engage... This is an automated request, but not an unsolicited one. For more information please visit http://gump.apache.org/nagged.html, and/or contact the folk at gene...@gump.apache.org. Project poi has an issue affecting its community integration. This issue affects 1 projects, and has been outstanding for 2 runs. The current state of this project is 'Failed', with reason 'Build Failed'. For reference only, the following projects are affected by this: - poi : POI Full details are available at: http://vmgump.apache.org/gump/public/poi/poi/index.html That said, some information snippets are provided here. The following annotations (debug/informational/warning/error messages) were provided: -DEBUG- Output [poi-ooxml-gump-17122008.jar] identifier set to output basename: [poi-ooxml-gump] -DEBUG- Output [poi-contrib-gump-17122008.jar] identifier set to output basename: [poi-contrib-gump] -DEBUG- Output [poi-scratchpad-gump-17122008.jar] identifier set to output basename: [poi-scratchpad-gump] -DEBUG- Output [poi-gump-17122008.jar] identifier set to output basename: [poi-gump] -INFO- Failed with reason build failed -DEBUG- Extracted fallback artifacts from Gump Repository The following work was performed: http://vmgump.apache.org/gump/public/poi/poi/gump_work/build_poi_poi.html Work Name: build_poi_poi (Type: Build) Work ended in a state of : Failed Elapsed: 3 mins 11 secs Command Line: /usr/lib/jvm/java-1.5.0-sun/bin/java -Djava.awt.headless=true -Xbootclasspath/p:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis.jar:/srv/gump/public/workspace/xml-xerces2/build/xercesImpl.jar:/srv/gump/public/workspace/xml-xalan/build/serializer.jar:/srv/gump/public/workspace/xml-xalan/build/xalan-unbundled.jar org.apache.tools.ant.Main -Dgump.merge=/srv/gump/public/gump/work/merge.xml -Dbuild.sysclasspath=only -Dversion.id=gump -DDSTAMP=17122008 -f build.xml gump [Working Directory: /srv/gump/public/workspace/poi] CLASSPATH: /usr/lib/jvm/java-1.5.0-sun/lib/tools.jar:/srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.3.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/jsr173_1.0_api.jar:/srv/gump/public/workspace/poi/ooxml-lib/ooxml-schemas-1.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/openxml4j-1.0-beta.jar:/srv/gump/public/workspace/poi/build/classes:/srv/gump/public/workspace/poi/build/contrib-classes:/srv/gump/public/workspace/poi/build/scratchpad-classes:/srv/gump/public/workspace/poi/build/ooxml-classes:/srv/gump/public/workspace/poi/build/test-classes:/srv/gump/public/workspace/poi/build/scratchpad-test-classes:/srv/gump/public/workspace/poi/build/ooxml-test-classes:/srv/gump/public/workspace/ant/dist/lib/ant-jmf.jar:/srv/gump/public/workspace/ant/dist/lib/ant-swing.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-resolver.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-xalan2.jar:/srv/gump/public/workspace/ant/dist/lib/ant-trax.jar:/srv/gump/public/workspace/ant/di st/lib/ant-junit.jar:/srv/gump/public/workspace/ant/dist/lib/ant-launcher.jar:/srv/gump/public/workspace/ant/dist/lib/ant-nodeps.jar:/srv/gump/public/workspace/ant/dist/lib/ant.jar:/srv/gump/public/workspace/logging-log4j-12/dist/lib/log4j-17122008.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-17122008.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-17122008.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-17122008.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-17122008.jar:/srv/gump/public/workspace/apache-commons/lang/commons-lang-17122008.jar:/srv/gump/public/workspace/junit/dist/junit-17122008.jar:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis-ext.jar:/srv/gump/public/workspace/dom4j/build/dom4j.jar - Buildfile: /srv/gump/public/workspace/poi/build.xml check-jars: fetch-jars: testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/commons-logging/jars/commons-logging-1.1.jar [get] To: /srv/gump/public/workspace/poi/lib/commons-logging-1.1.jar [get] Error getting http://www.ibiblio.org/maven/commons-logging/jars/commons-logging-1.1.jar to /srv/gump/public/workspace/poi/lib/commons-logging-1.1.jar BUILD FAILED /srv/gump/public/workspace/poi/build.xml:334: The following error occurred while executing this line: /srv/gump/public/workspace/poi/build.xml:316: java.net.ConnectException: Connection timed out Total time: 3 minutes 10 seconds - To subscribe to this information via syndicated feeds: - RSS: http://vmgump.apache.org/gump/public/poi/poi/rss.xml - Atom: http://vmgump.apache.org/gump/public/poi/poi/atom.xml == Gump Tracking Only === Produced by Gump version 2.3. Gump Run 1717122008, vmgump:vmgump-public:1717122008 Gump E-mail Identifier (unique
