[Bug 62275] vlookup function with "empty" fourth argument can not be processed.

[bugzilla]

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

--- Comment #3 from dolphin.in.the.sky...@gmail.com ---
This bug is not fixed.

Even in the latest nightly build, it is reproduced with the following code.

CreationHelper crateHelper = wb.getCreationHelper();
FormulaEvaluator eval = crateHelper.createFormulaEvaluator();
Cell cell = row.getCell(columnIndex);
eval.evaluate(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

Jenkins build is back to normal : POI-DSL-1.8 #477

[Apache Jenkins Server]

See 



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

[Bug 62575] New: XSSFWorkbook containing XSSFPivotTable is corrupt if workbook-data was written by SXSSFWorkbook

[bugzilla]

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

Bug ID: 62575
   Summary: XSSFWorkbook containing XSSFPivotTable is corrupt if
workbook-data was written by SXSSFWorkbook
   Product: POI
   Version: 3.17-FINAL
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: SXSSF
  Assignee: dev@poi.apache.org
  Reporter: gent.j...@gmx.net
  Target Milestone: ---

Created attachment 36052
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36052=edit
Example class to reproduce the bug.

If a workbook is created as SXSSFWorkbook and than (re)read as XSSFWorkbook a
XSSFPivotTable can be created. But if the xlsx file is opened, excel complains
about removed/repaired features.

-- 
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 62575] XSSFWorkbook containing XSSFPivotTable is corrupt if workbook-data was written by SXSSFWorkbook

[bugzilla]

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

PJ Fanning  changed:

   What|Removed |Added

 OS||All

--- Comment #1 from PJ Fanning  ---
Could you add the stacktrace?

-- 
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 62275] vlookup function with "empty" fourth argument can not be processed.

[bugzilla]

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

--- Comment #4 from PJ Fanning  ---
Could you provide a full test case?

-- 
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 62575] XSSFWorkbook containing XSSFPivotTable is corrupt if workbook-data was written by SXSSFWorkbook

[bugzilla]

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

--- Comment #2 from torsten  ---
There is no stacktrace. The workbook is updated without any message / failure.

The problem is visible if the workbook is opened in excel (and probably in open
office) only.

-- 
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 62576] New: autoSizeColumn columns is throwing null pointer exception

[bugzilla]

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

Bug ID: 62576
   Summary: autoSizeColumn columns is throwing null pointer
exception
   Product: POI
   Version: 3.17-FINAL
  Hardware: PC
OS: Linux
Status: NEW
  Severity: normal
  Priority: P2
 Component: HSSF
  Assignee: dev@poi.apache.org
  Reporter: j...@inbucketmail.tk
  Target Milestone: ---

doing:

sheet.autoSizeColumn(i);

java.lang.NullPointerException
at sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264)
at
sun.awt.FontConfiguration.readFontConfigFile(FontConfiguration.java:219)
at sun.awt.FontConfiguration.init(FontConfiguration.java:107)
at
sun.awt.X11FontManager.createFontConfiguration(X11FontManager.java:774)
at sun.font.SunFontManager$2.run(SunFontManager.java:431)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.SunFontManager.(SunFontManager.java:376)
at sun.awt.FcFontManager.(FcFontManager.java:35)
at sun.awt.X11FontManager.(X11FontManager.java:57)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:442)
at sun.font.FontManagerFactory$1.run(FontManagerFactory.java:83)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74)
at java.awt.Font.getFont2D(Font.java:491)
at java.awt.Font.canDisplayUpTo(Font.java:2060)
at java.awt.font.TextLayout.singleFont(TextLayout.java:470)
at java.awt.font.TextLayout.(TextLayout.java:531)
at
org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:275)
at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:250)
at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:235)
at
org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:549)
at
org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:531)

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

Jenkins build is back to normal : POI-DSL-Windows-1.8 #236

[Apache Jenkins Server]

See 



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

Jenkins build is back to normal : POI-DSL-OpenJDK #468

[Apache Jenkins Server]

See 



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

[Bug 62275] vlookup function with "empty" fourth argument can not be processed.

[bugzilla]

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

--- Comment #5 from dolphin.in.the.sky...@gmail.com ---
It reproduced with the following test case.

public void test62275_bug() throws IOException {
Workbook wb = new XSSFWorkbook();
Sheet sheet = wb.createSheet();
Row row = sheet.createRow(0);

Cell cell = row.createCell(0);
cell.setCellFormula("vlookup(A2,B1:B5,2,)");

CreationHelper crateHelper = wb.getCreationHelper();
FormulaEvaluator eval = crateHelper.createFormulaEvaluator();
eval.evaluate(cell);

wb.close();
}

-- 
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: [Bug 62275] vlookup function with "empty" fourth argument can not be processed.

[pj.fanning]

The current code blows up because the 4th param is empty (resulting in a
MissingArgEval issue) - the code will pass is the 4th param is set to the
true (the default for this param)  
https://www.techonthenet.com/excel/formulas/vlookup.php



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

[Bug 62576] autoSizeColumn columns is throwing null pointer exception

[bugzilla]

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

PJ Fanning  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from PJ Fanning  ---
Could you provide more details? A sample document, code to reproduce etc.?

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