Jenkins build is back to normal : POI-DSL-Maven #451

[Apache Jenkins Server]

See 



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

[GitHub] poi pull request #93: code cleaning according to ignored code review recomme...

[asfgit]

Github user asfgit closed the pull request at:

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


---

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

[Bug 56599] getDataValidations does not return dataValidations referring to different sheets.

[bugzilla]

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

--- Comment #2 from phili0...@gmx.de ---
Created attachment 35697
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35697&action=edit
Example sheet.xml extracted from an .xslx file, shows two storage locations for
data validations

-- 
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 56599] getDataValidations does not return dataValidations referring to different sheets.

[bugzilla]

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

--- Comment #1 from phili0...@gmx.de ---
This problem still exists. I looked inside the .xlsx file internals and noticed
that data validations refering to other sheets are stored at a different place.

If you call XSSFSheet.getDataValidations(), the data validations will be
extracted from CTWorksheet.getDataValidations(). But the data validations
refering to other sheets are stored in CTWorksheet.getExtList(), which cannot
be accessed by POI users.

In general it would be great if there would be a possibility to support these
type of data validations.

I also think that at the moment such data validations are stored at the wrong
place if you create it directly with 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 56599] getDataValidations does not return dataValidations referring to different sheets.

[bugzilla]

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

phili0...@gmx.de changed:

   What|Removed |Added

Version|3.10-FINAL  |4.0-dev

-- 
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 55713] DataValidation, getErrorStyle(), getEmptyCellAllowed() flags are wrong

[bugzilla]

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

--- Comment #4 from phili0...@gmx.de ---
I can confirm the problem with the errorStyle.

I you have a data validation with errorStyle = STOP, then
DataValidation.getErrorStyle() will return WARNING. I added an example and
junit test showing the problem.

I looked into the .xslx file internals and noticed that Excel does not save the
errorStyle attribute in the XML schema if the errorStyle equals STOP. So it
seems that the default value for errorStyle is wrong.


DataValidation.getEmptyCellAllowed() seems to work fine for me. I think the
problem is the name which is quite missleading compared to the Excel UI.
At least in the German Excel the attribute "emptyCellAllowed = true" equals to
the option "ignore empty cells". 

I think this is because the Excel UI wants to tell me something like "we won't
check empty cells" but the implementation defines it like "empty cells are
always valid".

-- 
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 55713] DataValidation, getErrorStyle(), getEmptyCellAllowed() flags are wrong

[bugzilla]

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

phili0...@gmx.de changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|INVALID |---
Version|3.7-FINAL   |4.0-dev

-- 
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 55713] DataValidation, getErrorStyle(), getEmptyCellAllowed() flags are wrong

[bugzilla]

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

--- Comment #3 from phili0...@gmx.de ---
Created attachment 35696
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35696&action=edit
Code and Example XLSX

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