[Bug 60184] Saved file that uses a XSSFFont without a specifically set FontFamily won't open in Excel

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60184

Javen O'Neal  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



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

2016-09-29 Thread 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 11 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 
30 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.155 seconds
  [xmlbean] Time to generate code: 12.151 seconds
 [copy] Copying 7 files to 
/srv/gump/public/workspace/poi/build/xmlbean-sources
[javac] Compiling 4575 

Re: Apache POI 3.15 released

2016-09-29 Thread Nick Burch

On 29/09/16 15:29, Javen O'Neal wrote:

Do we archive the release notes somewhere so that someone can read a
high-level summary of the changes for each release? Digging through
the dev@ email list archive to find the release notes draft or
searching a web archiver of one of the mirrors at a date in the past
seem suboptimal. There is no release notes file in the subversion tag
or a page on our site that summarizes the changes in a release more
concisely than changes.html.

The current https://poi.apache.org links to both 3.14 and 3.15, but we
overwrote the 3.14 release notes on
https://www.apache.org/dyn/closer.lua/poi/release/RELEASE-NOTES.txt
and all mirrors when we released 3.15.


After a final release, the homepage and download page should only ever 
link to the most current final version. No other versions should live on 
the dist area, otherwise infra get grumpy...


When we do an alpha or beta release, then homepage + download should 
link to both


If we don't already, it might be good to deploy the release notes twice, 
once as "RELEASE-NOTES.txt" (overwritten often), once as 
"RELEASE-NOTES-.txt". The latter would then always be 
available from archive.apache.org even after a newer final release. 
Thoughts?


Nick


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



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

2016-09-29 Thread 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 poi-test has an issue affecting its community integration.
This issue affects 1 projects.
The current state of this project is 'Failed', with reason 'Build Failed'.
For reference only, the following projects are affected by this:
- poi-test :  POI


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

That said, some information snippets are provided here.

The following annotations (debug/informational/warning/error messages) were 
provided:
 -INFO- Failed with reason build failed
 -INFO- Project Reports in: /srv/gump/public/workspace/poi/build/test-results
 -INFO- Project Reports in: 
/srv/gump/public/workspace/poi/build/scratchpad-test-results
 -INFO- Project Reports in: 
/srv/gump/public/workspace/poi/build/ooxml-test-results
 -INFO- Project Reports in: 
/srv/gump/public/workspace/poi/build/excelant-test-results



The following work was performed:
http://vmgump.apache.org/gump/public/poi/poi-test/gump_work/build_poi_poi-test.html
Work Name: build_poi_poi-test (Type: Build)
Work ended in a state of : Failed
Elapsed: 22 mins 15 secs
Command Line: /usr/lib/jvm/java-8-oracle/bin/java -Djava.awt.headless=true 
-Dbuild.sysclasspath=only org.apache.tools.ant.Main 
-Dgump.merge=/srv/gump/public/gump/work/merge.xml 
-Djavax.xml.stream.XMLInputFactory=com.sun.xml.internal.stream.XMLInputFactoryImpl
 -Dversion.id=gump-20160929 -DDSTAMP=20160929 test 
[Working Directory: /srv/gump/public/workspace/poi]
CLASSPATH: 
/usr/lib/jvm/java-8-oracle/lib/tools.jar:/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/poi/build/excelant-test-classes:/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/logging-log4j-12/target/log4j-1.2.18-SNAPSHOT.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-20160929.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-20160929.jar:/srv/gump/public/work
 
space/commons-codec-1.x/dist/commons-codec-20160929.jar:/srv/gump/public/workspace/apache-commons/collections/target/commons-collections4-4.2-SNAPSHOT.jar:/srv/gump/packages/jacoco/lib/jacocoant.jar:/srv/gump/public/workspace/xmlsec/target/xmlsec-2.0.8-SNAPSHOT.jar:/srv/gump/public/workspace/junit/target/junit-4.13-SNAPSHOT.jar:/srv/gump/packages/hamcrest/hamcrest-core-1.3.jar:/srv/gump/public/workspace/poi/build/dist/maven/poi/poi-gump-20160929.jar:/srv/gump/public/workspace/poi/build/dist/maven/poi-scratchpad/poi-scratchpad-gump-20160929.jar:/srv/gump/public/workspace/poi/build/dist/maven/poi-ooxml/poi-ooxml-gump-20160929.jar:/srv/gump/public/workspace/poi/build/dist/maven/poi-excelant/poi-excelant-gump-20160929.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/g
 
ump/public/workspace/poi/compile-lib/slf4j-api-1.7.12.jar:/srv/gump/public/workspace/poi/ooxml-lib/ooxml-schemas-1.3.jar:/srv/gump/public/workspace/poi/ooxml-lib/ooxml-security-1.1.jar
-
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFDataValidation
[junit] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 
2.563 sec
[junit] Running 
org.apache.poi.xssf.usermodel.TestXSSFDataValidationConstraint
[junit] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 
0.119 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFDialogSheet
[junit] Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 
1.004 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFDrawing
[junit] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 
7.25 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFExternalFunctions
[junit] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 
0.434 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFFont
[junit] Tests run: 21, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 
1.075 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFForkedEvaluator
[junit] Tests run: 2, Failures: 0

[Bug 60184] Saved file that uses a XSSFFont without a specifically set FontFamily won't open in Excel

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60184

--- Comment #4 from a...@vaadin.com ---
Behaviour was already present in 3.12, not sure about older ones. Don't have a
unit test, tested manually in existing project. I tested the files attached to
the linked ticket on Excel 2013 and Excel Viewer, with Libre Office they worked
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



Re: Apache POI 3.15 released

2016-09-29 Thread Javen O'Neal
Do we archive the release notes somewhere so that someone can read a
high-level summary of the changes for each release? Digging through
the dev@ email list archive to find the release notes draft or
searching a web archiver of one of the mirrors at a date in the past
seem suboptimal. There is no release notes file in the subversion tag
or a page on our site that summarizes the changes in a release more
concisely than changes.html.

The current https://poi.apache.org links to both 3.14 and 3.15, but we
overwrote the 3.14 release notes on
https://www.apache.org/dyn/closer.lua/poi/release/RELEASE-NOTES.txt
and all mirrors when we released 3.15.

On Thu, Sep 29, 2016 at 4:19 PM, Javen O'Neal  wrote:
> Nevermind. Just need to update the POI homepage to link to release
> instead of dev.
>
> On Thu, Sep 29, 2016 at 4:13 PM, Javen O'Neal  wrote:
>> The release notes have not made it to the apache and non-apache
>> mirrors. The release notes reference "3.15-beta 2" for me. Did the
>> 3.15 final release notes get published correctly?
>>
>> https://www.apache.org/dyn/closer.lua/poi/dev/RELEASE-NOTES.txt
>>
>> On Thu, Sep 22, 2016 at 7:34 PM, Javen O'Neal  wrote:
>>> 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

>>>

-
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

2016-09-29 Thread Javen O'Neal
Nevermind. Just need to update the POI homepage to link to release
instead of dev.

On Thu, Sep 29, 2016 at 4:13 PM, Javen O'Neal  wrote:
> The release notes have not made it to the apache and non-apache
> mirrors. The release notes reference "3.15-beta 2" for me. Did the
> 3.15 final release notes get published correctly?
>
> https://www.apache.org/dyn/closer.lua/poi/dev/RELEASE-NOTES.txt
>
> On Thu, Sep 22, 2016 at 7:34 PM, Javen O'Neal  wrote:
>> 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
>>>
>>

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



[Bug 59734] Named range creation & lookup are linear in the number of ranges

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59734

--- Comment #7 from Javen O'Neal  ---
I added a note on the new dependency to the changelog for the 3.15 release and
I think it was mentioned in the release notes.[1]

I realized that this dependency addition should have been added to the release
notes after the release had been generated.[2]

[1] https://poi.apache.org/changes.html
[2] https://www.apache.org/dyn/closer.lua/poi/release/RELEASE-NOTES.txt

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

2016-09-29 Thread Javen O'Neal
The release notes have not made it to the apache and non-apache
mirrors. The release notes reference "3.15-beta 2" for me. Did the
3.15 final release notes get published correctly?

https://www.apache.org/dyn/closer.lua/poi/dev/RELEASE-NOTES.txt

On Thu, Sep 22, 2016 at 7:34 PM, Javen O'Neal  wrote:
> 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
>>
>

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



[Bug 60184] Saved file that uses a XSSFFont without a specifically set FontFamily won't open in Excel

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60184

--- Comment #3 from a...@vaadin.com ---
Does the status change mean that you couldn't reproduce the issue with Excel
Viewer?

-- 
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 60184] Saved file that uses a XSSFFont without a specifically set FontFamily won't open in Excel

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60184

Javen O'Neal  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

-- 
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 60187] New: RegionUtil should use new enum style classes

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60187

Bug ID: 60187
   Summary: RegionUtil should use new enum style classes
   Product: POI
   Version: 3.15-FINAL
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: SS Common
  Assignee: dev@poi.apache.org
  Reporter: cam...@free.fr

RegionUtil has to change some methods to switch old int/short value to new
enums classes (like BorderStyle, HorizontalAlignment, FillPatternType...)

Actually, with version 3.15, we have some output lines like :
BorderStyle short usage

I use RegionUtil with merged zones, to put some border, with the following code
:
protected static void addMergedRegion(Sheet sheet, int iRowMin, int iRowMax,
int iColMin, int iColMax) {
CellRangeAddress cellZone = new CellRangeAddress(iRowMin, iRowMax, iColMin,
iColMax);
sheet.addMergedRegion(cellZone);

Cell cell = sheet.getRow(iRowMin).getCell(iColMin);
if (cell != null) {
   
RegionUtil.setBorderBottom(cell.getCellStyle().getBorderBottomEnum().getCode(),
cellZone, sheet);
   
RegionUtil.setBorderTop(cell.getCellStyle().getBorderTopEnum().getCode(),
cellZone, sheet);
   
RegionUtil.setBorderLeft(cell.getCellStyle().getBorderLeftEnum().getCode(),
cellZone, sheet);
   
RegionUtil.setBorderRight(cell.getCellStyle().getBorderRightEnum().getCode(),
cellZone, sheet);

   
RegionUtil.setBottomBorderColor(cell.getCellStyle().getBottomBorderColor(),
cellZone, sheet);
RegionUtil.setTopBorderColor(cell.getCellStyle().getTopBorderColor(),
cellZone, sheet);
RegionUtil.setLeftBorderColor(cell.getCellStyle().getLeftBorderColor(),
cellZone, sheet);
   
RegionUtil.setRightBorderColor(cell.getCellStyle().getRightBorderColor(),
cellZone, sheet);
}
}


Maybe, there is a new way to do the same thing, but I don't find it.

I have submitted a question here :
http://stackoverflow.com/questions/39765675/

-- 
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 59734] Named range creation & lookup are linear in the number of ranges

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59734

--- Comment #6 from David North  ---
Simplicity/good developers don't write what they can steal.

Apologies for not noting the new dependency in the change log - I'll add a note
to our release process to make sure this is covered next time round.

-- 
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 60184] Saved file that uses a XSSFFont without a specifically set FontFamily won't open in Excel

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60184

--- Comment #2 from a...@vaadin.com ---
LibreOffice doesn't have the problem, Excel does. Also reproducible in Excel
Viewer.

-- 
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 60184] Saved file that uses a XSSFFont without a specifically set FontFamily won't open in Excel

2016-09-29 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60184

--- Comment #1 from Javen O'Neal  ---
Created attachment 34312
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34312=edit
unit test

I am unable to reproduce this on the trunk (currently a few commits after 3.15)
using LibreOffice 4.2.8.2. I can check with Microsoft Excel later.

Is this behavior a regression in 3.15?
Can you verify that my unit test is the same as yours (if not, could you submit
your 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