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

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62040

--- Comment #2 from cque...@gmail.com ---
(In reply to Dominik Stadler from comment #1)
> Do you have a code-sample that shows the problem? Ideally a self-standing
> unit-test? Would make it much easier to reproduce and ensure it stays fixed
> in the future.

I'm not at all familiar with your testing methods. What I did was load an Excel
spreadsheet evaluate it and compare the results visually and with poi. I could
write a simple Excel file and the POI unit test to show fail on the error. Is
that OK?

-- 
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 61928] Incorrext XLSB extraction

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61928

--- Comment #3 from Tim Allison  ---
Does this behavior differ from XSSFEventBasedExcelExtractor?

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



Build failed in Jenkins: POI-DSL-Maven #462

2018-02-08 Thread Apache Jenkins Server
See 


Changes:

[centic] Bug 62042: Adjust gradle build to properly set the locale

[centic] Various smaller adjustments: Remove filename in test, remove unused 
parameters, fix a few simple typos in JavaDoc and add more JavaDoc and some 
more tests

--
[...truncated 657.57 KB...]
Running org.apache.poi.hssf.record.aggregates.TestCFRecordsAggregate
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.poi.hssf.record.aggregates.TestCFRecordsAggregate
Running org.apache.poi.hssf.record.aggregates.TestColumnInfoRecordsAggregate
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.poi.hssf.record.aggregates.TestColumnInfoRecordsAggregate
Running org.apache.poi.hssf.record.TestFtCblsSubRecord
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestFtCblsSubRecord
Running org.apache.poi.hssf.record.TestObjRecord
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestObjRecord
Running org.apache.poi.hssf.record.TestSCLRecord
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestSCLRecord
Running org.apache.poi.hssf.record.TestRecalcIdRecord
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestRecalcIdRecord
Running org.apache.poi.hssf.record.TestExtendedFormatRecord
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestExtendedFormatRecord
Running org.apache.poi.hssf.record.TestDrawingRecord
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestDrawingRecord
Running org.apache.poi.hssf.record.TestUnicodeNameRecord
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestUnicodeNameRecord
Running org.apache.poi.hssf.record.TestCommonObjectDataSubRecord
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestCommonObjectDataSubRecord
Running org.apache.poi.hssf.record.TestFeatRecord
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestFeatRecord
Running org.apache.poi.hssf.record.TestDrawingGroupRecord
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestDrawingGroupRecord
Running org.apache.poi.hssf.record.TestTableRecord
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestTableRecord
Running org.apache.poi.hssf.record.TestSupBookRecord
Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestSupBookRecord
Running org.apache.poi.hssf.record.TestAutoFilterInfoRecord
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestAutoFilterInfoRecord
Running org.apache.poi.hssf.record.TestNoteStructureSubRecord
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestNoteStructureSubRecord
Running org.apache.poi.hssf.record.TestCFRuleRecord
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.296 sec - in 
org.apache.poi.hssf.record.TestCFRuleRecord
Running org.apache.poi.hssf.record.TestDConRefRecord
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestDConRefRecord
Running org.apache.poi.hssf.record.TestExternalNameRecord
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.poi.hssf.record.TestExternalNameRecord
Running org.apache.poi.hssf.record.TestWriteAccessRecord
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestWriteAccessRecord
Running org.apache.poi.hssf.record.TestSSTRecord
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.038 sec - in 
org.apache.poi.hssf.record.TestSSTRecord
Running org.apache.poi.hssf.record.TestHyperlinkRecord
Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.poi.hssf.record.TestHyperlinkRecord
Running org.apache.poi.hssf.record.TestTextObjectBaseRecord
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in 
org.apache.poi.hssf.record.TestTextObjectBaseRecord
Running org.apache.poi.hssf.record.TestNameRecord
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.poi.hssf.record.TestNameRecord
Running org.apache.poi.hssf.record.TestLabelRecord
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec - in 
org.apache.poi.hssf.record.TestLabelRecord
Running 

[Bug 61928] Incorrext XLSB extraction

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61928

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #2 from Dominik Stadler  ---
Can you provide sample files and code that shows the problem to make it
possible for others to reproduce the described behavior?

-- 
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 61949] XSSFTable should support create/update functions

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61949

Dominik Stadler  changed:

   What|Removed |Added

   Severity|normal  |enhancement

-- 
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 61947] Remove deprecated classes (POI 4.0.0)

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61947

Dominik Stadler  changed:

   What|Removed |Added

   Severity|normal  |enhancement

-- 
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 61959] Provide support to create single slide SlideShow given multi slides SlideShow

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61959

Dominik Stadler  changed:

   What|Removed |Added

   Severity|major   |enhancement

-- 
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 61964] I cannot read an XLXS file created by MSSQL report

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61964

Dominik Stadler  changed:

   What|Removed |Added

 Resolution|--- |WORKSFORME
 Status|NEEDINFO|RESOLVED

--- Comment #2 from Dominik Stadler  ---
No answer on the question for a month, thus closing this for now, please
provide 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 61987] Updating excel file opended with OPCPackage throws: OpenXML4JRuntimeException: Rule M2.4 exception

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61987

Dominik Stadler  changed:

   What|Removed |Added

 Resolution|--- |DUPLICATE
 Status|NEW |RESOLVED

--- Comment #3 from Dominik Stadler  ---
Closing as duplicate of bug 60102 as it seems the order of close/write is wrong
here.

*** This bug has been marked as a duplicate of bug 60102 ***

-- 
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 60102] Improve error message when writing a document that has been closed

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60102

Dominik Stadler  changed:

   What|Removed |Added

 CC||cbenagara...@gmail.com

--- Comment #7 from Dominik Stadler  ---
*** Bug 61987 has been marked as a duplicate of 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 62021] XSSF fails to add time as String to date

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62021

Dominik Stadler  changed:

   What|Removed |Added

   Severity|normal  |enhancement

-- 
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 62040] Quotient.evaluate function does not accept cell refences

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62040

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from Dominik Stadler  ---
Do you have a code-sample that shows the problem? Ideally a self-standing
unit-test? Would make it much easier to reproduce and ensure it stays fixed in
the future.

-- 
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 62055] XSSFImportFromXML does not add table rows

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62055

--- Comment #2 from Dominik Stadler  ---
A PR on GitHub is perfectly fine!

-- 
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 62042] gradle build fails

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62042

Dominik Stadler  changed:

   What|Removed |Added

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

--- Comment #6 from Dominik Stadler  ---
This should be fixed via r1823596, you can also use the following as a
workaround:

LANG=en_US.UTF-8 LANGUAGE= LC_ALL= gradle check

-- 
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 56885] To change text in a XWPFSDTContent object

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=56885

--- Comment #4 from NadavB  ---
Is there any progress regarding handling and manipulation of SDT tags? (Content
Tags)?

-- 
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 62055] XSSFImportFromXML does not add table rows

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62055

--- Comment #1 from leonard.ka...@fokus.fraunhofer.de ---
I've created a pull request on Github: https://github.com/apache/poi/pull/99

Are pull request on Github ok or are patch files preferred? This is my first
contribution for this project, if there are issues with the pull request I'll
gladly try to improve 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



[GitHub] poi pull request #99: Bug-62055 - Fix XSSFImportFromXML table resize

2018-02-08 Thread kapep
GitHub user kapep opened a pull request:

https://github.com/apache/poi/pull/99

Bug-62055 - Fix XSSFImportFromXML table resize

Fixes [Bug-62055](https://bz.apache.org/bugzilla/show_bug.cgi?id=62055) and 
one other issues with the XSSFImportFromXML.

The main change is that importing `XSSFImportFromXML.importFromXML` now 
resizes mapped tables when importing XML data. Each table will have the a row 
count of exactly the amount of imported elements, i.e. it shrinks or grows 
accordingly. When growing, cells below the table are overwritten.

The other issue this fixes is that table column id's were wrongly used to 
get the column position. This resulted in data written to wrong columns when 
the id did not match the positions.

Additional checks have been added to the tests for both issues. Changes to 
`CustomXMLMappings-complex-type.xlsx` include: 
- Added an additional (unmapped) column to verify that data is written to 
correct columns when the column id doesn't match the columns position
- Added some text in a cell below a table that will grow, to check if the 
cell is correctly overwritten when the table grows
- Added some text in a cell inside a table that will shrink, to check if 
the cell is correctly cleared when the shrinks

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/kapep/poi 
Bug62055_XSSFImportFromXML-table-resize

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/poi/pull/99.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #99


commit 3a4fce7b2bd1fedd634c35f4e084630add6a583b
Author: Leonard Kappe 
Date:   2018-02-06T19:24:25Z

Bug 62055: Resize tables when importing XML map




---

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



[Bug 62055] XSSFImportFromXML does not add table rows

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62055

Dominik Stadler  changed:

   What|Removed |Added

   Severity|normal  |minor

-- 
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 62055] XSSFImportFromXML does not add table rows

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62055

Dominik Stadler  changed:

   What|Removed |Added

 OS||All

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

2018-02-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62066

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO
 OS||All

--- Comment #1 from Dominik Stadler  ---
Its impossible to analyze, reproduce or let alone fix your problem with the
small amount of information that you provide. What is your code? Is there a
sample file? Which operating system do you use?

Please try to provide a reproducible standalone test-case which shows the
problem, otherwise there is likely not much we can do here.

-- 
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: Discontinue Apache POI in Gump

2018-02-08 Thread Dominik Stadler
Done via https://svn.apache.org/viewvc?view=revision=1823548, I
removed the poi.xml and removed it from gump.xml, I did not find any other
occurences of "POI" in there.

Thanks... Dominik.

On Wed, Feb 7, 2018 at 10:09 PM, Stefan Bodewig  wrote:

> On 2018-02-07, Dominik Stadler wrote:
>
> > The Apache POI PMC held a vote (
> > http://mail-archives.apache.org/mod_mbox/poi-dev/201802.
> mbox/%3cCABdJj56tn5hL_a+gADZD6bC4txxfUUph1aHyqhyDowMkw
> +p...@mail.gmail.com%3e)
> > and came to the conclusion that Gump does not provide enough value for
> > us to keep putting in the effort maintaining it.
>
> This reminds me I wanted to reach out to the few projects that still use
> Gump. Good timing.
>
> > Thus we would like to remove Apache POI from the Gump setup.
>
> > Should I just give it a try myself as everybody has commit access?
>
> I had a quick look and no other project depends on POI so it should be
> safe to remove the project descriptor as well as the refernce to it from
> the gump.xml profile. If you want to give it a try, go ahead. Please ask
> if you need a hand.
>
> Cheers
>
> Stefan
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> For additional commands, e-mail: dev-h...@poi.apache.org
>
>