[Bug 62040] Quotient.evaluate function does not accept cell refences

[bugzilla]

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

--- Comment #4 from Dominik Stadler  ---
Any update on the sample file and unit-test?

-- 
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 62066] autoSizeColumn(int i) has a bug

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |LATER

--- Comment #2 from Dominik Stadler  ---
We cannot reproduce the problem with the scarce information that was provided,
so we cannot do much here unless we get more information. Thus closing this as
LATER for now, please reopen with more information if this is still a problem
for you.

-- 
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 62081] java.lang.OutOfMemoryError: Map failed occurs when processing a bunch of msg files

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |LATER

--- Comment #2 from Dominik Stadler  ---
We cannot reproduce the problem with the information that was provided. No
sample file was provided, so we cannot do much here unless we get more
information. Thus closing this as LATER for now, please reopen with more
information if this is still a problem for you.

-- 
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 62084] Issue with date format

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Resolution|--- |LATER
 Status|NEEDINFO|RESOLVED

--- Comment #4 from Dominik Stadler  ---
We cannot reproduce the problem with only screenshots, no sample file was
provided, so we cannot do much here unless we get more information. Thus
closing this as LATER for now, please reopen with more information if this is
still a problem for you.

-- 
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 62108] ArrayIndexOfBounds exception when getColumnWidth()

[bugzilla]

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

--- Comment #7 from Dominik Stadler  ---
Look at
https://builds.apache.org/view/P/view/POI/job/POI-DSL-1.8/lastSuccessfulBuild/artifact/
for latest build results.

-- 
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 62129] java.lang.ArrayIndexOutOfBoundsException when HWPFDocument read word

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Resolution|--- |WONTFIX
 Status|NEW |RESOLVED

--- Comment #1 from Dominik Stadler  ---
This is actually some sort of HTML file that is prepended with some data to
allows Word to open it. 

Apache POI does not have support for such files currently and there are no
plans to add support anytime soon unless someone steps up and provides patches
and proper unit-tests.

You should try to write the file in one of the official Office-formats which
should be supported to some degree in recent versions of Apache POI
(unfortunately support for Word-formats is not fully done yet...).

-- 
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 62144] RuntimeException: Shared formula record should follow a FormulaRecord

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Resolution|--- |LATER
 Status|NEW |RESOLVED

--- Comment #3 from Dominik Stadler  ---
We cannot do much without a file that reproduces the problem, thus closing as
LATER for now, please reopen with a sample file that we can use to reproduce
the problem.

-- 
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 62151] Illegal reflective access by org.apache.poi.util.DocumentHelper and org.apache.poi.util is accessible from more than one module

[bugzilla]

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

--- Comment #2 from Dominik Stadler  ---
I think a first step will be Automatic-Module-Name in the MANIFEST.MF of the
jar-files, see
http://branchandbound.net/blog/java/2017/12/automatic-module-name/, need to
read up some more on this before starting on adding this, though.

-- 
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: publishing poi xmlbeans jars

[Dave Fisher]

> On Apr 2, 2018, at 10:23 AM, Dave Fisher  wrote:
> 
> Hi Mark,
> 
> We will need to make INFRA JIRA tickets with reference to the VOTE part of 
> this thread.
> 
> (1) Put XMLBeans svn repos under POI LDAP.

INFRA-16278 
> (2) Put the website under POI LDAP
> (3) Take admin rights on the XMLBeans JIRA.
> 
> Once that has been done we’ll need to then work on making our bug fixes and 
> then going through a release.
> 
> Regards,
> Dave
> 
>> On Apr 2, 2018, at 10:15 AM, Mark Murphy  wrote:
>> 
>> So where are we on this?
>> 
>> On Wed, Mar 7, 2018 at 12:40 PM, Dave Fisher  wrote:
>> 
>>> Hi -
>>> 
>>> Let’s get back on track.
>>> 
>>> We want to release XMLBeans 2.7.0 with the org.apache.xmlbeans namespace
>>> for the benefit of all of the users who are dependent on it. If POI does
>>> not want to do this then XMLBeans will need to go to the Incubator.
>>> 
>>> Should we VOTE?
>>> 
>>> If yes then we can ask Infra to open the JIRA and move the svn somewhere
>>> with the history. We also ask for the return of the website to our LDAP.
>>> 
>>> Regards,
>>> Dave
>>> 
 On Mar 7, 2018, at 4:04 AM, Murphy, Mark 
>>> wrote:
 
 If we do that, it needs to be in a major release because namespaces
>>> change. If we are going to repackage to support Java 9 modules, that should
>>> also happen at the same time.
 
 -Original Message-
 From: pj.fanning [mailto:fannin...@yahoo.com]
 Sent: Tuesday, March 06, 2018 4:35 PM
 To: dev@poi.apache.org
 Subject: Re: publishing poi xmlbeans jars
 
 I have an experimental xmlbeans jar where I changed the package name to
>>> org.apache.poi.xmlbeans just to see if it was feasible to get it build. I
>>> also have a poi branch that successfully uses this jar.
 https://repo1.maven.org/maven2/com/github/pjfanning/
>>> xmlbeans/2.7.0-beta1/
 It should be feasible to use a commons based package name if that was
>>> the route we went.
 
 
 
 --
 Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html
 
 -
 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
 
>>> 
>>> 
> 



signature.asc
Description: Message signed with OpenPGP

Re: publishing poi xmlbeans jars

[Dave Fisher]

Hi Mark,

We will need to make INFRA JIRA tickets with reference to the VOTE part of this 
thread.

(1) Put XMLBeans svn repos under POI LDAP.
(2) Put the website under POI LDAP
(3) Take admin rights on the XMLBeans JIRA.

Once that has been done we’ll need to then work on making our bug fixes and 
then going through a release.

Regards,
Dave

> On Apr 2, 2018, at 10:15 AM, Mark Murphy  wrote:
> 
> So where are we on this?
> 
> On Wed, Mar 7, 2018 at 12:40 PM, Dave Fisher  wrote:
> 
>> Hi -
>> 
>> Let’s get back on track.
>> 
>> We want to release XMLBeans 2.7.0 with the org.apache.xmlbeans namespace
>> for the benefit of all of the users who are dependent on it. If POI does
>> not want to do this then XMLBeans will need to go to the Incubator.
>> 
>> Should we VOTE?
>> 
>> If yes then we can ask Infra to open the JIRA and move the svn somewhere
>> with the history. We also ask for the return of the website to our LDAP.
>> 
>> Regards,
>> Dave
>> 
>>> On Mar 7, 2018, at 4:04 AM, Murphy, Mark 
>> wrote:
>>> 
>>> If we do that, it needs to be in a major release because namespaces
>> change. If we are going to repackage to support Java 9 modules, that should
>> also happen at the same time.
>>> 
>>> -Original Message-
>>> From: pj.fanning [mailto:fannin...@yahoo.com]
>>> Sent: Tuesday, March 06, 2018 4:35 PM
>>> To: dev@poi.apache.org
>>> Subject: Re: publishing poi xmlbeans jars
>>> 
>>> I have an experimental xmlbeans jar where I changed the package name to
>> org.apache.poi.xmlbeans just to see if it was feasible to get it build. I
>> also have a poi branch that successfully uses this jar.
>>> https://repo1.maven.org/maven2/com/github/pjfanning/
>> xmlbeans/2.7.0-beta1/
>>> It should be feasible to use a commons based package name if that was
>> the route we went.
>>> 
>>> 
>>> 
>>> --
>>> Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html
>>> 
>>> -
>>> 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
>>> 
>> 
>> 



signature.asc
Description: Message signed with OpenPGP

[Bug 62174] class org.openxmlformats.schemas.wordprocessingml.x2006.main.STHeightRule not found in jar file

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |FIXED

--- Comment #2 from Dominik Stadler  ---
Added some simple unit tests for 4.0.0 via r1828180 which will cause this
classes to be included in the poi-ooxml-schemas jar file.

-- 
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 61267] Extract text from Microsoft Word 2.0 (pre-OLE2) document

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |WONTFIX

--- Comment #5 from Dominik Stadler  ---
In r1828176 we have added detection for word2 files and thus now make it easier
to spot that Apache POI does not support this type of file. 

I think there are currently no plans to fully support this very old format,
please reopen this with initial patches for review if you are interested in
this feature and you can work on implementing and maintaining this.

-- 
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: publishing poi xmlbeans jars

[Mark Murphy]

So where are we on this?

On Wed, Mar 7, 2018 at 12:40 PM, Dave Fisher  wrote:

> Hi -
>
> Let’s get back on track.
>
> We want to release XMLBeans 2.7.0 with the org.apache.xmlbeans namespace
> for the benefit of all of the users who are dependent on it. If POI does
> not want to do this then XMLBeans will need to go to the Incubator.
>
> Should we VOTE?
>
> If yes then we can ask Infra to open the JIRA and move the svn somewhere
> with the history. We also ask for the return of the website to our LDAP.
>
> Regards,
> Dave
>
> > On Mar 7, 2018, at 4:04 AM, Murphy, Mark 
> wrote:
> >
> > If we do that, it needs to be in a major release because namespaces
> change. If we are going to repackage to support Java 9 modules, that should
> also happen at the same time.
> >
> > -Original Message-
> > From: pj.fanning [mailto:fannin...@yahoo.com]
> > Sent: Tuesday, March 06, 2018 4:35 PM
> > To: dev@poi.apache.org
> > Subject: Re: publishing poi xmlbeans jars
> >
> > I have an experimental xmlbeans jar where I changed the package name to
> org.apache.poi.xmlbeans just to see if it was feasible to get it build. I
> also have a poi branch that successfully uses this jar.
> > https://repo1.maven.org/maven2/com/github/pjfanning/
> xmlbeans/2.7.0-beta1/
> > It should be feasible to use a commons based package name if that was
> the route we went.
> >
> >
> >
> > --
> > Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html
> >
> > -
> > 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 62216] SXSSFCell.setCellErrorValue turns a formula cell into an error cell, unlike XSSF

[bugzilla]

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

PJ Fanning  changed:

   What|Removed |Added

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

-- 
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 62216] SXSSFCell.setCellErrorValue turns a formula cell into an error cell, unlike XSSF

[bugzilla]

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

--- Comment #5 from PJ Fanning  ---
The test case works with and without the change with poi trunk (4.0.0 pre
release) but does fail with 3.17 code base.
I've added the test case to trunk.

-- 
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 62216] SXSSFCell.setCellErrorValue turns a formula cell into an error cell, unlike XSSF

[bugzilla]

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

--- Comment #4 from gallon.fi...@gmail.com  ---
(In reply to PJ Fanning from comment #3)
> Hi Gallon,
> That test passes even without the change in
> https://svn.apache.org/viewvc?view=revision=1828144

That's weird. With poi 3.17 it fails for me with
java.lang.IllegalStateException: Cannot get a FORMULA value from a ERROR cell.

It passes with an XSSFWorkbook, though.

When I have time, I can check out trunk and try it myself.

-- 
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 61474] Adjusting of formulas in context of column shifting

[bugzilla]

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

--- Comment #29 from PJ Fanning  ---
https://github.com/apache/poi/pull/81 was merged

-- 
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 62216] SXSSFCell.setCellErrorValue turns a formula cell into an error cell, unlike XSSF

[bugzilla]

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

--- Comment #3 from PJ Fanning  ---
Hi Gallon,
That test passes even without the change in
https://svn.apache.org/viewvc?view=revision=1828144

-- 
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 62247] Support for LineStyle in XSSFComment

[bugzilla]

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

PJ Fanning  changed:

   What|Removed |Added

 OS||All

--- Comment #1 from PJ Fanning  ---
Hi Mayur,
Would you be able to provide a Pull Request on https://github.com/apache/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 62247] New: Support for LineStyle in XSSFComment

[bugzilla]

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

Bug ID: 62247
   Summary: Support for LineStyle in XSSFComment
   Product: POI
   Version: 3.17-FINAL
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: XSSF
  Assignee: dev@poi.apache.org
  Reporter: mayur.ancha...@gmail.com
  Target Milestone: ---

XSSFComment doesn't have support for Linestyle similar to HSSFComment

In HSSFComment we have functions like setLineStyle and setLineStyleColor,
similar feature is required for XSSFComment .

-- 
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 62230] Formula evaluation fails when using matrix multiplication within SUM function call with #VALUE!

[bugzilla]

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

Alexander Vitkovskiy  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

-- 
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 62216] SXSSFCell.setCellErrorValue turns a formula cell into an error cell, unlike XSSF

[bugzilla]

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

--- Comment #2 from gallon.fi...@gmail.com  ---
(In reply to PJ Fanning from comment #1)
> I added the suggested change using
> https://svn.apache.org/viewvc?view=revision=1828144
> 
> Would it be possible to get a test case for regression purposes?

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.FormulaError;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.junit.Test;

import static org.junit.Assert.assertEquals;

public class SXSSFCellTest {
@Test
public void test62216() {
Cell instance = new
SXSSFWorkbook().createSheet().createRow(0).createCell(0);

String formula = "2";
instance.setCellFormula(formula);
instance.setCellErrorValue(FormulaError.NAME.getCode());

String result = instance.getCellFormula();
assertEquals(formula, result);
}
}

-- 
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 62242] Shouldn't show '0' if number format is "??" and cell value is 0

[bugzilla]

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

--- Comment #2 from linghao2...@hotmail.com ---
I'm not sure whether it's a bug or a feature. Maybe for some reasons, the zero
character must appear at least once?
If nobody knows that, I can create a pull request and do some unit test, a few
days later. I need more time to confirm the current logic.

-- 
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 62222] getLabel for Hyperlink returns always null for xlsx files

[bugzilla]

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

Alexander Vitkovskiy  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #7 from Alexander Vitkovskiy  ---
Yes, string Cell velue gives display text for hyperlink (not sure that always
will match hyperlynk label from hyperlink properties).

But if you trying to create hyperlink from code and save it to xlsx, there no
way to save Label. If you creating hyperlink with Label Excel will show blank
display text\cell and setting string Cell value replacing hyperlink in cell.

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