[Bug 57721] Evaluating formulas in named Excel table

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721

Javen O'Neal  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #10 from Javen O'Neal  ---
Closing. This was added to the changelog under Version 3.15-beta2 (2016-07-02)
https://poi.apache.org/changes.html

-- 
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

[Bug 59836] Tracker: Replace primitives with enums

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=59836

--- Comment #1 from Javen O'Neal  ---
Todo: update https://poi.apache.org/spreadsheet/quick-guide.html

-- 
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

[GUMP@vmgump]: Project ooxml-schemas (in module poi) failed

[Gump [HEAD] :-(]

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 ooxml-schemas has an issue affecting its community integration.
This issue affects 5 projects,
 and has been outstanding for 2 runs.
The current state of this project is 'Failed', with reason 'Build Timed Out'.
For reference only, the following projects are affected by this:
- ooxml-schemas :  POI
- org.apache.poi :  POI
- poi :  POI
- poi-ooxml-schemas :  POI
- poi-test :  POI


Full details are available at:
http://vmgump.apache.org/gump/public/poi/ooxml-schemas/index.html

That said, some information snippets are provided here.

The following annotations (debug/informational/warning/error messages) were 
provided:
 -DEBUG- Sole jar output [ooxml-schemas-[0-9]*[0-9T].jar] identifier set to 
project name
 -INFO- Failed with reason build timed out
 -INFO- Failed to extract fallback artifacts from Gump Repository



The following work was performed:
http://vmgump.apache.org/gump/public/poi/ooxml-schemas/gump_work/build_poi_ooxml-schemas.html
Work Name: build_poi_ooxml-schemas (Type: Build)
Work ended in a state of : Failed
Elapsed: 1 hour 3 secs
Command Line: /usr/lib/jvm/java-8-oracle/bin/java -Djava.awt.headless=true 
-Dbuild.sysclasspath=only -Dant.build.clonevm=true org.apache.tools.ant.Main 
-Dgump.merge=/srv/gump/public/gump/work/merge.xml compile-ooxml-xsds 
[Working Directory: /srv/gump/public/workspace/poi]
CLASSPATH: 
/usr/lib/jvm/java-8-oracle/lib/tools.jar:/srv/gump/public/workspace/ant/dist/lib/ant.jar:/srv/gump/public/workspace/ant/dist/lib/ant-launcher.jar:/srv/gump/public/workspace/ant/dist/lib/ant-jmf.jar:/srv/gump/public/workspace/ant/dist/lib/ant-junit.jar:/srv/gump/public/workspace/ant/dist/lib/ant-junit4.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/xml-commons/java/build/resolver.jar:/srv/gump/public/workspace/poi/ooxml-lib/curvesapi-1.04.jar:/srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.6.0.jar.orig:/srv/gump/public/workspace/poi/compile-lib/bcpkix-jdk15on-1.54.jar:/srv/gump/public/workspace/poi/compile-lib/bcprov-ext-jdk15on-1.54.jar:/srv/gump/public/workspace/poi/compile-lib/slf4j-api-1.7.12.jar
-
Buildfile: /srv/gump/public/workspace/poi/build.xml

check-jars:

fetch-jars:

check-ooxml-jars:

fetch-ooxml-jars:

init:
 [echo] Using Ant: Apache Ant(TM) version 1.10.0alpha compiled on September 
23 2016 from ${ant.home}, Ant detected Java 1.8 (may be different than actual 
Java sometimes...)
 [echo] Using Java: 1.8.0_60/1.8.0_60-b27/25.60-b23/Java HotSpot(TM) 64-Bit 
Server VM from Oracle Corporation on Linux: 3.13.0-66-generic
 [echo] Using Findbugs: 3.0.1 for Java 1.8.0_60

check-ooxml-xsds:

fetch-ooxml-xsds:
  [get] Getting: 
http://www.ecma-international.org/publications/files/ECMA-ST/Office%20Open%20XML%201st%20edition%20Part%204%20(PDF).zip
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part4.zip
  [get] Getting: 
http://www.ecma-international.org/publications/files/ECMA-ST/Office%20Open%20XML%201st%20edition%20Part%202%20(PDF).zip
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part2.zip
  [get] Getting: 
https://www.w3.org/TR/2002/REC-xmldsig-core-20020212/xmldsig-core-schema.xsd
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/xmldsig-core-schema.xsd
  [get] Getting: http://uri.etsi.org/01903/v1.3.2/XAdES.xsd
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/XAdES.xsd
  [get] Getting: http://uri.etsi.org/01903/v1.4.1/XAdESv141.xsd
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/XAdESv141.xsd
[unzip] Expanding: 
/srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part4.zip into 
/srv/gump/public/workspace/poi/ooxml-lib
[unzip] Expanding: 
/srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part2.zip into 
/srv/gump/public/workspace/poi/ooxml-lib
[unzip] Expanding: 
/srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part4.zip into 
/srv/gump/public/workspace/poi/ooxml-lib

check-compiled-ooxml-xsds:

compile-ooxml-xsds:
[mkdir] Created dir: /srv/gump/public/workspace/poi/build/xmlbean-xsds
[mkdir] Created dir: /srv/gump/public/workspace/poi/build/xmlbean-sources
[mkdir] Created dir: /srv/gump/public/workspace/poi/build/xmlbean-classes
 [copy] Copying 2 files to /srv/gump/public/workspace/poi/build/xmlbean-xsds
 [copy] Copying 87 resources to 
/srv/gump/public/workspace/poi/build/xmlbean-xsds
  [xmlbean] Time to build schema type system: 5.155 seconds
  [xmlbean] Time to generate code: 9.96 seconds
 [copy] Copying 7 files to 

[Bug 60163] Text coloring in Excel cell is not working

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60163

Javen O'Neal  changed:

   What|Removed |Added

 Resolution|FIXED   |WORKSFORME

--- Comment #5 from Javen O'Neal  ---
The code from comment 1 was tested on a SXSSFWorkbook and colors the text (not
background fill). Coloring part of the text in a cell requires RichTextStrings,
which SXSSF does not currently support. Supporting this would require
maintaining a shared strings table, negating some of the memory benefits of
SXSSF.

We will happily review submitted patches and unit tests for optionally allowing
a shared strings table and rich text strings in SXSSF if they meet the needs of
the community.

-- 
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

[Bug 60163] Text coloring in Excel cell is not working

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60163

Ratna  changed:

   What|Removed |Added

 Resolution|WORKSFORME  |---
 Status|RESOLVED|REOPENED

--- Comment #2 from Ratna  ---
for the particular TEXT in Cell,i want coloring.
Not the entire cell,if you have example provide me please.

-- 
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

[Bug 60163] Text coloring in Excel cell is not working

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60163

--- Comment #3 from Ratna  ---
Also U r saying example for XSSF workbook,i want to work it for SXSSF
workbook,not XSSF work book

-- 
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

[Bug 60163] Text coloring in Excel cell is not working

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60163

Nick Burch  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|REOPENED|RESOLVED

--- Comment #4 from Nick Burch  ---
(In reply to Ratna from comment #2)
> for the particular TEXT in Cell,i want coloring.
> Not the entire cell,if you have example provide me please.

Bugzilla is only for bug reports and patches. Please ask usage questions on the
mailing list

-- 
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

[Bug 60165] negative dates in poi for java application doesn't supported?

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

Nick Burch  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #5 from Nick Burch  ---
Can you please write a short junit unit test that highlights the problem? With
no code, we have a very low chance of being able to fix bugs (if any)

-- 
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

[Bug 60163] Text coloring in Excel cell is not working

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60163

Javen O'Neal  changed:

   What|Removed |Added

 OS||All
 Resolution|--- |WORKSFORME
 Status|NEW |RESOLVED
   Severity|critical|enhancement

--- Comment #1 from Javen O'Neal  ---
This works for me. Adapted from
https://poi.apache.org/spreadsheet/quick-guide.html#Hyperlinks

CellStyle style = wb.createCellStyle();
Font font = wb.createFont();
font.setUnderline(Font.U_SINGLE);
font.setColor(IndexedColors.BLUE.getIndex());
style.setFont(font);

Sheet sheet = wb.createSheet();
Cell cell = sheet.createRow(0).createCell(0);
cell.setCellValue("Underlined Blue Text");
cell.setCellStyle(style);

In the future, please ask usage questions on the user or dev mailing lists
rather than opening a bug. https://poi.apache.org/mailinglists.html

-- 
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

[Bug 57721] Evaluating formulas in named Excel table

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721

Javen O'Neal  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #8 from Javen O'Neal  ---
Is anything else needed to close this bug?

-- 
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

[Bug 60163] New: Text coloring in Excel cell is not working

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60163

Bug ID: 60163
   Summary: Text coloring in Excel cell is not working
   Product: POI
   Version: 3.13-FINAL
  Hardware: PC
Status: NEW
  Severity: critical
  Priority: P2
 Component: SXSSF
  Assignee: dev@poi.apache.org
  Reporter: ratnachar...@gmail.com

Hi Team,

We are using Apache Poi 3.13 final jars.

We used SXSSF workbook for an export of records using MS Xcel.

Records are exporting but,Workbook's apply font method is not working and
beacuse of this coloring of text in the excel columns is not at all working.

Being low memory adaption technique in SXSSF work book,apply font wont work,i
know this.
But can u please suggest a working solution,without changing the SXSSF
workbook?
If any jar change may work,please suggest.

Thanks a lot
Ratna

-- 
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: Switch to maven?

[Javen O'Neal]

I have added Gradle support in r1761871 [1] with one line of code,
though requires that Ant be installed on the system.

I would like to leapfrog Maven. While it does offer some dependency
benefits and enjoys pretty high market share, reading and writing XML
is something that should be reserved exclusively for computers, and
that's my biggest gripe with Ant.

Whatever solution we go with, we probably want to maintain 2 solutions
in parallel for a year or more while we rewrite the build targets in
build.xml into the new build file(s).

Informally, here's the relative popularity of these build tools over
the last 5 years. Maven is the de facto standard for Java projects,
but build tools with DSLs (Gradle: Groovy, SBT: Scala, Bazel: Python)
are gaining popularity.
https://www.google.com/trends/explore?cat=5=Ant,Ivy,Maven,Gradle,SBT
which is roughly the same as
https://www.google.com/trends/explore?cat=5=build.xml,pom.xml,build.gradle,.sbt
but is less likely to include queries about insects and plants.

Another heartbeat is to search large open source code repositories to
see what kinds of build tools are being used. Unfortunately,
github.com/search is garbage if you want to search for exact file
names.
Searching google.com for each build filename, we get:
build.xml (Ant): 2.33 million
pom.xml (Maven): 3.3 million
build.gradle (Gradle): 0.49 million
.sbt (Scala Build Tool): 0.399 million
Gradle: 1073

[1] https://svn.apache.org/viewvc?view=revision=1761871

On Thu, Mar 10, 2016 at 4:42 AM, Nick Burch  wrote:
> On Thu, 10 Mar 2016, Dominik Stadler wrote:
>>
>> Here a few initial ideas where we could improve this:
>>
>> 1. Add some CI to the Github project so that PRs are automatically
>> verified
>
>
> I think some other Apache projects already do something like this. Maybe ask
> on dev@community
>
>> 2. Move to Git/Github
>
>
> Moving to Github is not allowed. See dev@community and board@ for
> discussions and details. Other than an experiment with Whimsy, ASF source
> control systems (either SVN or GIT-WIP) must remain the canonical source
>
> Moving to Git is possible, and Tika has just done so. Needs documentation,
> and guideance, again dev@community probably the best place to ask for advice
> on that
>
>> 5. Use some donation-scheme for bugfixes so people affected by bugs can
>> offer some compensation and developers can make some money for fixing
>> certain bugs
>
>
> You need to take care here - targetted donations are not allowed, and no-one
> can promise that any fix will be accepted by the project. (Someone could pay
> you to write a patch that removes Excel support, for example, and while you
> could take their money and write them the patch, the community would veto
> applying it to trunk! Extreme example, but gives the idea)
>
> I'd suggest you go watch / listen to a previous "The Apache Way" talk :)
>
> Bug bounties can be done, but need a bit of care. general@incubator has some
> discussions on this, probably more than dev@community, as the incubator has
> more people learning how to adapt to Apache-like development. Ask, learn,
> implement! :)
>
> 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

[Bug 60165] negative dates in poi for java application doesn't supported?

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

--- Comment #6 from Javen O'Neal  ---
Possibly relevant:
https://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDateUtil.java?view=markup

I believe POI supports 1900 dates, which is what Microsoft Excel uses. The
xls/xslx format cannot represent earlier dates.
Search the developer list and pasy bugs. I think this question has come up
before for users trying to represent medieval and BC dates.

https://support.office.com/en-us/article/DATE-function-e36c0c8c-4104-49da-ab83-82328b832349

-- 
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: Apache POI 3.15 released

[Javen O'Neal]

Good point!

A one sentence "Apache POI is a Java library for reading and writing
Microsoft Office files" should do. We'll add this to our announce template
for future releases.

On Sep 22, 2016 9:28 AM, "sebb"  wrote:

> What is the project about? Why should I be interested in it?
> [rhetorical questions]
>
> The Announce emails are sent to people not on the developer or user lists.
> Most will have no idea what the project is about.
>
> So the e-mails should contain at least brief details of what the
> product does, and some info on why the new release might be of
> interest to them.
>
> Readers should not have to click the link to find out the basic information
> (although of course it is useful to have such links for further detail).
>
> Please can you add that information to future announce mails?
>
> Thanks.
>
> On 21 September 2016 at 23:32, David North  wrote:
> > The Apache POI PMC are pleased to announce the release of Apache POI
> 3.15.
> >
> > For details of changes in this release, refer to the release notes:
> >
> > https://www.apache.org/dyn/closer.lua/poi/release/RELEASE-NOTES.txt
> >
> > Thank you to all our contributors for making this release possible.
> >
> > Some of us will be at ApacheCon Europe in Seville later in the year; do
> > find us there if you have input and suggestions.
> >
> > On behalf of the Apache POI PMC,
> >
> > David North
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> For additional commands, e-mail: dev-h...@poi.apache.org
>
>

[Bug 60165] negative dates

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

--- Comment #1 from Vasily S  ---
Created attachment 34291
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34291=edit
negative dates in excel and scell

Example how it looks in excel and scell. Scell can be downloaded from
http://scell.org/download.html

-- 
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

[Bug 60165] negative dates in java application doesn't supported?

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

Vasily S  changed:

   What|Removed |Added

   Keywords||APIBug
Summary|negative dates  |negative dates in java
   ||application doesn't
   ||supported?

-- 
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

[Bug 60165] negative dates in poi for java application doesn't supported?

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

--- Comment #3 from Vasily S  ---
Created attachment 34292
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34292=edit
Example xlsx for negative date

load file in excel and in java with poi and look at F39

-- 
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

[Bug 60165] negative dates in poi for java application doesn't supported?

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

--- Comment #4 from Vasily S  ---
It needs the support of the POI library: use 1904 date system

-- 
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: Switch to maven?

[Javen O'Neal]

Looks like.we will lose Gump support if we upgrade to Maven2 or Gradle, not
that we have been doing much with the Gump CI build timeout errors.

https://en.wikipedia.org/wiki/Comparison_of_continuous_integration_software

On Sep 22, 2016 03:23, "Javen O'Neal"  wrote:

> I have added Gradle support in r1761871 [1] with one line of code,
> though requires that Ant be installed on the system.
>
> I would like to leapfrog Maven. While it does offer some dependency
> benefits and enjoys pretty high market share, reading and writing XML
> is something that should be reserved exclusively for computers, and
> that's my biggest gripe with Ant.
>
> Whatever solution we go with, we probably want to maintain 2 solutions
> in parallel for a year or more while we rewrite the build targets in
> build.xml into the new build file(s).
>
> Informally, here's the relative popularity of these build tools over
> the last 5 years. Maven is the de facto standard for Java projects,
> but build tools with DSLs (Gradle: Groovy, SBT: Scala, Bazel: Python)
> are gaining popularity.
> https://www.google.com/trends/explore?cat=5=Ant,Ivy,Maven,Gradle,SBT
> which is roughly the same as
> https://www.google.com/trends/explore?cat=5=build.xml,pom.
> xml,build.gradle,.sbt
> but is less likely to include queries about insects and plants.
>
> Another heartbeat is to search large open source code repositories to
> see what kinds of build tools are being used. Unfortunately,
> github.com/search is garbage if you want to search for exact file
> names.
> Searching google.com for each build filename, we get:
> build.xml (Ant): 2.33 million
> pom.xml (Maven): 3.3 million
> build.gradle (Gradle): 0.49 million
> .sbt (Scala Build Tool): 0.399 million
> Gradle: 1073
>
> [1] https://svn.apache.org/viewvc?view=revision=1761871
>
> On Thu, Mar 10, 2016 at 4:42 AM, Nick Burch  wrote:
> > On Thu, 10 Mar 2016, Dominik Stadler wrote:
> >>
> >> Here a few initial ideas where we could improve this:
> >>
> >> 1. Add some CI to the Github project so that PRs are automatically
> >> verified
> >
> >
> > I think some other Apache projects already do something like this. Maybe
> ask
> > on dev@community
> >
> >> 2. Move to Git/Github
> >
> >
> > Moving to Github is not allowed. See dev@community and board@ for
> > discussions and details. Other than an experiment with Whimsy, ASF source
> > control systems (either SVN or GIT-WIP) must remain the canonical source
> >
> > Moving to Git is possible, and Tika has just done so. Needs
> documentation,
> > and guideance, again dev@community probably the best place to ask for
> advice
> > on that
> >
> >> 5. Use some donation-scheme for bugfixes so people affected by bugs can
> >> offer some compensation and developers can make some money for fixing
> >> certain bugs
> >
> >
> > You need to take care here - targetted donations are not allowed, and
> no-one
> > can promise that any fix will be accepted by the project. (Someone could
> pay
> > you to write a patch that removes Excel support, for example, and while
> you
> > could take their money and write them the patch, the community would veto
> > applying it to trunk! Extreme example, but gives the idea)
> >
> > I'd suggest you go watch / listen to a previous "The Apache Way" talk :)
> >
> > Bug bounties can be done, but need a bit of care. general@incubator has
> some
> > discussions on this, probably more than dev@community, as the incubator
> has
> > more people learning how to adapt to Apache-like development. Ask, learn,
> > implement! :)
> >
> > Nick
> >
> >
> > -
> > To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> > For additional commands, e-mail: dev-h...@poi.apache.org
> >
>

[Bug 60165] New: negative dates

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

Bug ID: 60165
   Summary: negative dates
   Product: POI
   Version: unspecified
  Hardware: All
OS: All
Status: NEW
  Severity: major
  Priority: P2
 Component: SS Common
  Assignee: dev@poi.apache.org
  Reporter: v.smelt...@intechcore.de

-- 
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

[Bug 60165] negative dates in poi for java application doesn't supported?

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

Vasily S  changed:

   What|Removed |Added

Summary|negative dates in java  |negative dates in poi for
   |application doesn't |java application doesn't
   |supported?  |supported?

-- 
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

[Bug 60165] negative dates in poi for java application doesn't supported?

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60165

--- Comment #2 from Vasily S  ---
it seeams, that negative dates don't supported in actuall version of poi.

-- 
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

[Bug 59021] XSSFSheetXMLHandler is using qName instead of localName and missing cells/rows

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=59021

--- Comment #4 from Ed  ---
Created attachment 34294
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34294=edit
Excel file broken with the change

The attached excel file is generated by Microsoft Excel 2016 for Mac. The file
can no longer be extracted since 3.14 after the change in this ticket is
introduced. As I debug startElement() function call, uri is empty but not null
(""). Also localName is empty while qName is present.

-- 
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

[Bug 57721] Evaluating formulas in named Excel table

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721

Greg Woolsey  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #9 from Greg Woolsey  ---
I think the other patches accepted for Structured Reference syntax cover this. 
I've been on other tasks for a bit, will be digging back into the project that
needed this shortly.  If I find anything else, it would be new bugs filed
separately (hopefully with patches :D )

-- 
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

[Bug 59021] XSSFSheetXMLHandler is using qName instead of localName and missing cells/rows

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=59021

--- Comment #5 from Nick Burch  ---
(In reply to Ed Chu from comment #4)
> Created attachment 34294 [details]
> Excel file broken with the change

Can you try with a more recent version of POI? I've just tried with the most
recent, and I see the same text from POI and Tika as I do in OpenOffice ("Table
1" but that's about it)

-- 
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: Apache POI 3.15 released

[sebb]

What is the project about? Why should I be interested in it?
[rhetorical questions]

The Announce emails are sent to people not on the developer or user lists.
Most will have no idea what the project is about.

So the e-mails should contain at least brief details of what the
product does, and some info on why the new release might be of
interest to them.

Readers should not have to click the link to find out the basic information
(although of course it is useful to have such links for further detail).

Please can you add that information to future announce mails?

Thanks.

On 21 September 2016 at 23:32, David North  wrote:
> The Apache POI PMC are pleased to announce the release of Apache POI 3.15.
>
> For details of changes in this release, refer to the release notes:
>
> https://www.apache.org/dyn/closer.lua/poi/release/RELEASE-NOTES.txt
>
> Thank you to all our contributors for making this release possible.
>
> Some of us will be at ApacheCon Europe in Seville later in the year; do
> find us there if you have input and suggestions.
>
> On behalf of the Apache POI PMC,
>
> David North

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[GUMP@vmgump]: Project ooxml-schemas (in module poi) failed

[Gump [HEAD] :-(]

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 ooxml-schemas has an issue affecting its community integration.
This issue affects 5 projects.
The current state of this project is 'Failed', with reason 'Build Timed Out'.
For reference only, the following projects are affected by this:
- ooxml-schemas :  POI
- org.apache.poi :  POI
- poi :  POI
- poi-ooxml-schemas :  POI
- poi-test :  POI


Full details are available at:
http://vmgump.apache.org/gump/public/poi/ooxml-schemas/index.html

That said, some information snippets are provided here.

The following annotations (debug/informational/warning/error messages) were 
provided:
 -DEBUG- Sole jar output [ooxml-schemas-[0-9]*[0-9T].jar] identifier set to 
project name
 -INFO- Failed with reason build timed out
 -INFO- Failed to extract fallback artifacts from Gump Repository



The following work was performed:
http://vmgump.apache.org/gump/public/poi/ooxml-schemas/gump_work/build_poi_ooxml-schemas.html
Work Name: build_poi_ooxml-schemas (Type: Build)
Work ended in a state of : Failed
Elapsed: 1 hour 4 secs
Command Line: /usr/lib/jvm/java-8-oracle/bin/java -Djava.awt.headless=true 
-Dbuild.sysclasspath=only -Dant.build.clonevm=true org.apache.tools.ant.Main 
-Dgump.merge=/srv/gump/public/gump/work/merge.xml compile-ooxml-xsds 
[Working Directory: /srv/gump/public/workspace/poi]
CLASSPATH: 
/usr/lib/jvm/java-8-oracle/lib/tools.jar:/srv/gump/public/workspace/ant/dist/lib/ant.jar:/srv/gump/public/workspace/ant/dist/lib/ant-launcher.jar:/srv/gump/public/workspace/ant/dist/lib/ant-jmf.jar:/srv/gump/public/workspace/ant/dist/lib/ant-junit.jar:/srv/gump/public/workspace/ant/dist/lib/ant-junit4.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/xml-commons/java/build/resolver.jar:/srv/gump/public/workspace/poi/ooxml-lib/curvesapi-1.04.jar:/srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.6.0.jar.orig:/srv/gump/public/workspace/poi/compile-lib/bcpkix-jdk15on-1.54.jar:/srv/gump/public/workspace/poi/compile-lib/bcprov-ext-jdk15on-1.54.jar:/srv/gump/public/workspace/poi/compile-lib/slf4j-api-1.7.12.jar
-
Buildfile: /srv/gump/public/workspace/poi/build.xml

check-jars:

fetch-jars:

check-ooxml-jars:

fetch-ooxml-jars:

init:
 [echo] Using Ant: Apache Ant(TM) version 1.10.0alpha compiled on September 
22 2016 from ${ant.home}, Ant detected Java 1.8 (may be different than actual 
Java sometimes...)
 [echo] Using Java: 1.8.0_60/1.8.0_60-b27/25.60-b23/Java HotSpot(TM) 64-Bit 
Server VM from Oracle Corporation on Linux: 3.13.0-66-generic
 [echo] Using Findbugs: 3.0.1 for Java 1.8.0_60

check-ooxml-xsds:

fetch-ooxml-xsds:
  [get] Getting: 
http://www.ecma-international.org/publications/files/ECMA-ST/Office%20Open%20XML%201st%20edition%20Part%204%20(PDF).zip
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part4.zip
  [get] Getting: 
http://www.ecma-international.org/publications/files/ECMA-ST/Office%20Open%20XML%201st%20edition%20Part%202%20(PDF).zip
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part2.zip
  [get] Getting: 
https://www.w3.org/TR/2002/REC-xmldsig-core-20020212/xmldsig-core-schema.xsd
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/xmldsig-core-schema.xsd
  [get] Getting: http://uri.etsi.org/01903/v1.3.2/XAdES.xsd
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/XAdES.xsd
  [get] Getting: http://uri.etsi.org/01903/v1.4.1/XAdESv141.xsd
  [get] To: /srv/gump/public/workspace/poi/ooxml-lib/XAdESv141.xsd
[unzip] Expanding: 
/srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part4.zip into 
/srv/gump/public/workspace/poi/ooxml-lib
[unzip] Expanding: 
/srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part2.zip into 
/srv/gump/public/workspace/poi/ooxml-lib
[unzip] Expanding: 
/srv/gump/public/workspace/poi/ooxml-lib/OfficeOpenXML-Part4.zip into 
/srv/gump/public/workspace/poi/ooxml-lib

check-compiled-ooxml-xsds:

compile-ooxml-xsds:
[mkdir] Created dir: /srv/gump/public/workspace/poi/build/xmlbean-xsds
[mkdir] Created dir: /srv/gump/public/workspace/poi/build/xmlbean-sources
[mkdir] Created dir: /srv/gump/public/workspace/poi/build/xmlbean-classes
 [copy] Copying 2 files to /srv/gump/public/workspace/poi/build/xmlbean-xsds
 [copy] Copying 87 resources to 
/srv/gump/public/workspace/poi/build/xmlbean-xsds
  [xmlbean] Time to build schema type system: 6.154 seconds
  [xmlbean] Time to generate code: 9.446 seconds
 [copy] Copying 7 files to 
/srv/gump/public/workspace/poi/build/xmlbean-sources
[javac] Compiling 4575 source