Re: 3.15 beta 2 soon?

[Andreas Beeker]

Hi,

On 14.06.2016 20:31, Javen O'Neal wrote:
> If I am, I will happily be release manager.
This is good to hear/read - I'm happy to help you with the releasing as the 
scripts probably
still need some tuning, i.e. only the optimistic path (hopefully) works, but as 
soon as something needs
to be repeated, you still need need to a few manual tweaks ...

>  - What bugs do people still need to fix / finish fixing (eg the ones
>we're working with contributors on right now) before we can release
>another beta?
I work on #59702 ... should be finished in the next few days.
Apart of that I'm trying to fix the myriad of javadocs errors/warnings in the 
JDK8 build,
but this is on-going and can be easily paused while the releasing takes place.

Andi


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

[Bug 55273] Names referring to Excel tables have no associated sheet

[bugzilla]

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

--- Comment #1 from Javen O'Neal  ---
Added disabled unit test in r1748606. This fails on POI 3.15-beta 2 because
CellReference is used to parse the sheet name from "TableName[#All]", but
cannot handle this cell reference format.

-- 
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 59707] New: Create new line in cell doesn't work with BufferedReader

[bugzilla]

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

Bug ID: 59707
   Summary: Create new line in cell doesn't work with
BufferedReader
   Product: POI
   Version: 3.15-dev
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: XSSF
  Assignee: dev@poi.apache.org
  Reporter: rbi...@ribics.fr

Hi all,

First of all, many thanks for this amazing library.

I'm trying to create a new line in a cell by reading a file.
I've implemented the sample
https://poi.apache.org/spreadsheet/quick-guide.html#NewLinesInCells that works
fine.

I've modified the code in order to read an external file with the same content,
and the \n is written in the file instead of having a new line.

{code}
public static void readTextFile() {
BufferedReader br = null;
;
try {
br = new BufferedReader(new FileReader("C:/tmp/toto.txt"));
String fileLine = "";
String excelFileName = "C:/tmp/Test.xlsx";// name of excel file

String sheetName = "Sheet1";// name of sheet

XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet(sheetName);
while ((fileLine = br.readLine()) != null) {
System.out.println(fileLine);
Row row = sheet.createRow(2);
Cell cell = row.createCell(2);
cell.setCellValue(fileLine);
// to enable newlines you need set a cell styles with wrap=true
CellStyle cs = wb.createCellStyle();
cs.setWrapText(true);
cell.setCellStyle(cs);

}
FileOutputStream fileOut = new FileOutputStream(excelFileName);

// write this workbook to an Outputstream.
wb.write(fileOut);
fileOut.flush();
fileOut.close();
br.close();
} catch (IOException ioe) {
ioe.getMessage();
}
}
{code}

My file contains only :
Use \n with word wrap on to create a new line

I've tried with new XSSFRichTextString(fileLine), but the \n is still present
in the xlsx file.

Do i miss something ? Is it a bug ?

Thank you in advance for your replies and/or correction.

Rich.

-- 
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 59705] Wrong implementation of XSSFPivotTable.addColumnLabel() methods

[bugzilla]

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

--- Comment #2 from Chenna Kesavarao  ---
@Apache POI developers

Please verify it and resolve the ticket

-- 
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 59705] Wrong implementation of XSSFPivotTable.addColumnLabel() methods

[bugzilla]

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

--- Comment #1 from Chenna Kesavarao  ---
i have updated code accordingly to fix this issue.

i have created a new method XSSFPivotTable.addColumnLabel(int columnIndex) and
changed the names of existing XSSFPivotTable.addColumnLabel() methods to
XSSFPivotTable.addValueLabel()


New method, which i have added
---
  /**
 * Add a column label using data from the given column.
 * @param columnIndex the index of the column to be used as column label.
 */
@Beta
public void addColumnLabel(int columnIndex) {
AreaReference pivotArea = getPivotArea();
int lastRowIndex = pivotArea.getLastCell().getRow() -
pivotArea.getFirstCell().getRow();
int lastColIndex = pivotArea.getLastCell().getCol() -
pivotArea.getFirstCell().getCol();

if(columnIndex > lastColIndex) {
throw new IndexOutOfBoundsException();
}
CTPivotFields pivotFields = pivotTableDefinition.getPivotFields();

CTPivotField pivotField = CTPivotField.Factory.newInstance();
CTItems items = pivotField.addNewItems();

pivotField.setAxis(STAxis.AXIS_COL);
pivotField.setShowAll(false);
for(int i = 0; i <= lastRowIndex; i++) {
items.addNewItem().setT(STItemType.DEFAULT);
}
items.setCount(items.sizeOfItemArray());
pivotFields.setPivotFieldArray(columnIndex, pivotField);

CTColFields colFields;
if(pivotTableDefinition.getColFields() != null) {
colFields = pivotTableDefinition.getColFields();
} else {
colFields = pivotTableDefinition.addNewColFields();
}

colFields.addNewField().setX(columnIndex);
colFields.setCount(colFields.sizeOfFieldArray());
}



--
Change of previous existing XSSFPivotTable.addColumnLabel methods to
XSSFPivotTable.addValueLabel
-

-- 
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 59705] New: Wrong implementation of XSSFPivotTable.addColumnLabel() methods

[bugzilla]

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

Bug ID: 59705
   Summary: Wrong implementation of
XSSFPivotTable.addColumnLabel() methods
   Product: POI
   Version: 3.14-FINAL
  Hardware: PC
Status: NEW
  Severity: blocker
  Priority: P2
 Component: XSSF
  Assignee: dev@poi.apache.org
  Reporter: chenna...@intellicus.com

Created attachment 33950
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33950=edit
pivot table

Implementation for XSSFPivotTable.addColumnLabel() method was wrong. 

Implementation provided for XSSFPivotTable.addColumnLabel() methods is actually
the implementation for ValueLabel() methods.

If we are creating pivot tables using XSSFPivotTable.addColumnLabel(), the
field is adding to the Values position in the excel 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 59705] Wrong implementation of XSSFPivotTable.addColumnLabel() methods

[bugzilla]

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

Chenna Kesavarao  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 55273] Names referring to Excel tables have no associated sheet

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 OS|Linux   |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 57882] allow appending to large workbooks without reading

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #3 from Javen O'Neal  ---
Any updates on the JavaFX bug or suggested documentation (or example code
https://svn.apache.org/viewvc/poi/trunk/src/examples/)

-- 
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 55385] XSSFFont.setBoldweight(short) to 300 but getBoldweight return 400

[bugzilla]

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

--- Comment #4 from Javen O'Neal  ---
Or deprecate setBoldweight.

-- 
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 53320] FormulaShifter doesn't take care to absolute references

[bugzilla]

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

--- Comment #5 from Javen O'Neal  ---
This behavior may be by design. Shift rows isn't the same as insert rows. I'm
not sure if it's the same as cut-paste, either. I'd be happy to discuss this on
the dev 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 57697] Comments added have transparent textbox with no background color

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

Summary|Comments added have |Comments added have
   |tansparent textbox with no  |transparent textbox with no
   |background color|background color
 Resolution|--- |WORKSFORME
 Status|NEEDINFO|RESOLVED

--- Comment #2 from Javen O'Neal  ---
Closing due to no response in over a year.
Refer to the user guide how to create a cell comment in XSSF. With that code, I
get the default yellow background in Excel.

Please take usage questions to the POI user 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 57294] RichText is converted to nomal text in SXSSF

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Depends on||52972

-- 
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 52972] Enable RichText in SXSSF

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Blocks||57294

-- 
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 49202] Please add support for the function 'PERCENTRANK'.

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 OS|Windows Vista   |All
  Component|HSSF|SS Common

-- 
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 58227] Excel Data table not evaluated

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 OS|Mac OS X 10.4   |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 57840] [PATCH] Support for structured references with Excel tables.

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Blocks||58227

-- 
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 58227] Excel Data table not evaluated

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Depends on||57840

-- 
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 46670] Reference to cell in different workbook not possible

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

   Severity|major   |enhancement
 OS|Windows Vista   |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 58130] Support icon-based and data bars conditional formatting

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Blocks||58149

-- 
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 58149] Support Office 2010 extensions to Conditional Formatting

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Depends on||56205, 58130

-- 
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 56205] [PATCH] Upgrade OOXML schema to 3rd edition (transitional)

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Blocks||58149

-- 
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 52910] Not Finding all Merged Regions in Worksheet

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |INVALID

--- Comment #3 from Javen O'Neal  ---
No response. Closing the bug as invalid.

If you still have this problem in the latest release of POI, please reopen and
attach a file that demonstrates 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 49319] Clone sheets with drawings

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

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

--- Comment #1 from Javen O'Neal  ---


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

-- 
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 54470] [PATCH] Solution to support Graph in XSSFWorkbook.cloneSheet method

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 CC||charle...@gmail.com

--- Comment #9 from Javen O'Neal  ---
*** Bug 49319 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

RE: Finding deprecated methods

[Javen O'Neal]

Follow-on question: some deprecation warnings on say what the replacement
for the method or class is. Java's QuickFix sometimes gets it right if a
method is renamed, but punts when the parameters. Is there an easy way to
update old usages that's faster than per-usage or per-deprecation?

Is there a standard way we should be formatting our deprecation warnings to
make it trivial for our users to upgrade their code base?
On Jun 15, 2016 2:08 AM, "Uwe Schindler"  wrote:

> Hi,
>
> You can also download the JAR files of those releases and use a comparison
> tool like http://siom79.github.io/japicmp/ to compare them. This tool can
> be run using CLI and also prints changes in @Deprecated.
>
> The CLI syntax is here: http://siom79.github.io/japicmp/CliTool.html
>
> I always use "-m" (only show modified stuff) and "-o" and "-n" to specify
> the old and new JAR file. After that you can grep on something like
> DEPRECATED.
>
> Uwe
>
> -
> Uwe Schindler
> H.-H.-Meier-Allee 63, D-28213 Bremen
> http://www.thetaphi.de
> eMail: u...@thetaphi.de
>
> > -Original Message-
> > From: Nick Burch [mailto:apa...@gagravarr.org]
> > Sent: Wednesday, June 15, 2016 10:43 AM
> > To: POI Developers List 
> > Subject: Re: Finding deprecated methods
> >
> > On Tue, 14 Jun 2016, Javen O'Neal wrote:
> > > Is there a smarter way to find deprecated classes besides checking out
> > > the code from 2 final releases ago and removing any deprecated code
> that
> > > still exists in trunk@HEAD?
> >
> > I'd probably attempt it with:
> > * grep trunk for @deprecated with no date, with a -A 4 or similar, then
> >grab the method name from that
> > * grab a list of old versions from "svn ls ^/poi/tags/"
> > * use "svn switch ^/poi/tags//" to quickly walk your tree back
> through
> >older versions
> > * do the same greps, and spot where they vanish
> >
> > If that all sounds a bit hairy, let me know and I can try it later in the
> > week!
> >
> > 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
>
>

RE: Finding deprecated methods

[Uwe Schindler]

Hi,

You can also download the JAR files of those releases and use a comparison tool 
like http://siom79.github.io/japicmp/ to compare them. This tool can be run 
using CLI and also prints changes in @Deprecated.

The CLI syntax is here: http://siom79.github.io/japicmp/CliTool.html

I always use "-m" (only show modified stuff) and "-o" and "-n" to specify the 
old and new JAR file. After that you can grep on something like DEPRECATED.

Uwe

-
Uwe Schindler
H.-H.-Meier-Allee 63, D-28213 Bremen
http://www.thetaphi.de
eMail: u...@thetaphi.de

> -Original Message-
> From: Nick Burch [mailto:apa...@gagravarr.org]
> Sent: Wednesday, June 15, 2016 10:43 AM
> To: POI Developers List 
> Subject: Re: Finding deprecated methods
> 
> On Tue, 14 Jun 2016, Javen O'Neal wrote:
> > Is there a smarter way to find deprecated classes besides checking out
> > the code from 2 final releases ago and removing any deprecated code that
> > still exists in trunk@HEAD?
> 
> I'd probably attempt it with:
> * grep trunk for @deprecated with no date, with a -A 4 or similar, then
>grab the method name from that
> * grab a list of old versions from "svn ls ^/poi/tags/"
> * use "svn switch ^/poi/tags//" to quickly walk your tree back through
>older versions
> * do the same greps, and spot where they vanish
> 
> If that all sounds a bit hairy, let me know and I can try it later in the
> week!
> 
> 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

Re: Finding deprecated methods

[Nick Burch]

On Tue, 14 Jun 2016, Javen O'Neal wrote:
Is there a smarter way to find deprecated classes besides checking out 
the code from 2 final releases ago and removing any deprecated code that 
still exists in trunk@HEAD?


I'd probably attempt it with:
* grep trunk for @deprecated with no date, with a -A 4 or similar, then
  grab the method name from that
* grab a list of old versions from "svn ls ^/poi/tags/"
* use "svn switch ^/poi/tags//" to quickly walk your tree back through
  older versions
* do the same greps, and spot where they vanish

If that all sounds a bit hairy, let me know and I can try it later in the 
week!


Nick

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

Re: Git

[Nick Burch]

On Tue, 14 Jun 2016, Mark Murphy wrote:
Trying to find documentation site on Git, but it does not appear to 
exist. Is this true?


IIRC only trunk, branches and tags get mirrored into github. THe docs are 
in a different bit of the tree, in part so that the ASF webservers can 
watch svn for commits to the publish directory and immediately deploy the 
new files


We could ask for a mirror of docs too, if it would help, but I think the 
main copy needs to stay svn so the auto-deploy on publish work


Nick

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

[Bug 59670] Sheet.getRow().getCell() gets the value from the next sheet along

[bugzilla]

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

--- Comment #6 from Andreas Beeker  ---
(In reply to cbradford from comment #5)
> Have you had any further developments with this bug?

I had a quick try on this and can only confirm the bug.
Althougn the bound name is correct, I suspect that the vba sheet is causing an
error with the sheet references ... but maybe someone else with a deeper
knowledge of hssf can jump in?

-- 
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 59670] Sheet.getRow().getCell() gets the value from the next sheet along

[bugzilla]

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

--- Comment #5 from cbradf...@lintottcs.co.uk ---
Have you had any further developments with 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