[Bug 58408] Add visio schemas to the OOXML jar

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58408

Dominik Stadler  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|REOPENED|RESOLVED

--- Comment #8 from Dominik Stadler  ---
I think this is basically fixed, further work on refactoring the different
schema-jars should be handled in separate issues.

-- 
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 58694] org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58694

Dominik Stadler  changed:

   What|Removed |Added

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

--- Comment #2 from Dominik Stadler  ---
No response for some time on the request for more information, therefore I am
setting closing this for now. Please reopen this with more information if you
still have this problem with the latest version of 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 58266] org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Rule M2.4 exception : this error should NEVER happen, if so please send a mail to the developers team, thanks !

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58266

Dominik Stadler  changed:

   What|Removed |Added

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

--- Comment #4 from Dominik Stadler  ---
Without more info we likely cannot do much here, therefore I am closing this
until we get a sample document which triggers this error message.

-- 
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 35897] Password protected files

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=35897

Dominik Stadler  changed:

   What|Removed |Added

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

--- Comment #37 from Dominik Stadler  ---
As far as I see the latest patch from Andi is applied, so I am closing this as
FIXED, please open new bugs for any remaining problems as this one has quite a
long history and many changes were done to the code in the meantime.

-- 
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 35897] Password protected files

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=35897

Dominik Stadler  changed:

   What|Removed |Added

  Attachment #32258|1   |0
   is patch||
  Attachment #32258|text/plain  |application/zip
  mime type||

-- 
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 56499] IFERROR fails when written to spreadsheet

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=56499

Dominik Stadler  changed:

   What|Removed |Added

  Attachment #31611|0   |1
is obsolete||

--- Comment #9 from Dominik Stadler  ---
Created attachment 33560
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33560&action=edit
Testcase to produce the incorrect 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 56499] IFERROR fails when written to spreadsheet

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=56499

--- Comment #8 from Dominik Stadler  ---
Some analysis:
* IFERROR is not part of the default set of Excel functions, but is marked as
"external" in the parsed formula:
Ptg[7]=org.apache.poi.ss.formula.ptg.FuncVarPtg [#external# nArgs=3]V

* The externalname is added by POI as follows:
[EXTERNALNAME]
.options  = 0
.ix  = 0
.name= IFERROR
org.apache.poi.ss.formula.ptg.ErrPtg [#REF!].
[/EXTERNALNAME]

* When the file is edited and saved in Excel it is saved as follows:
[NAME]
.option flags   = 0x038B
.keyboard shortcut  = 0x00
.length of the name = 13
.extSheetIx(1-based, 0=Global)= 0
.sheetTabIx = 0
.Menu text length   = 0
.Description text length= 0
.Help topic text length = 0
.Status bar text length = 0
.NameIsMultibyte= false
.Name (Unicode text)= _xlfn.IFERROR
.Formula (nTokens=1):
   org.apache.poi.ss.formula.ptg.ErrPtg [#NAME?].
.Menu text   = 
.Description text= 
.Help topic text = 
.Status bar text = 
[/NAME]

* The external name is currently built in InternalWorkbook.getNameXPtg()

-- 
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 58339] [PATCH] Make OFFSET() accept missing parameters

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58339

Javen O'Neal  changed:

   What|Removed |Added

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

--- Comment #6 from Javen O'Neal  ---
Merged in r1730606 and r1730607.

Thanks for the patch, Patrick!

-- 
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 58418] Applying Auto Filter on SXSSFSheet leads to corrupt excel

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58418

Dominik Stadler  changed:

   What|Removed |Added

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

--- Comment #2 from Dominik Stadler  ---
Not enough information and no response, therefore closing this, please reopen
with more information (ideally a self-sufficient unit-test and any required
sample documents) 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 55476] [PATCH] Fixed: after XWPFRun.addPicture() Word considers the document as corrupted

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=55476

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #6 from Dominik Stadler  ---
I tried, but could not reproduce this problem, adding pictures worked fine,
Microsoft Word could open the document. See the unit-test added in r1730598.

Therefore I am closing this for now, if this is still does not work for you
with the latest version of POI then please provide the sample code and the
exact version of Microsoft Word that you are using to allow us to reproduce
this.

-- 
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 58339] [PATCH] Make OFFSET() accept missing parameters

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58339

--- Comment #5 from Javen O'Neal  ---
Nevermind, TestFormulasFromSpreadsheet.java handles the extra tests. No need
for new unit tests.

The current attached xls/xlsx files fail at TestFormulasFromSpreadsheet.java
because their locale is DE, so they use OktIndex rather than Oct2Dec, and other
locale-specific functions. However, Offset passes, so the changes are good.

I don't have access to EN locale Excel to copy your edits over at the moment.
I'll get to this in a week if no one else beats me to it. Presumably the only
changes were the addition of Offset formulas:

H1040 =SUM(OFFSET(K7:L8,0,0,1,1))
I1040 =SUM(OFFSET(K7:L8,0,0,1,))
J1040 =SUM(OFFSET(K7:L8,0,0,,1))
K1040 =SUM(OFFSET(K7:L8,0,0,1))
L1040 =SUM(OFFSET(K7:L8,0,0))
M1040 =SUM(OFFSET(K7:L8,0,0,,))
N1040 =SUM(OFFSET(K7:L8,0,0,))

-- 
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 58339] [PATCH] Make OFFSET() accept missing parameters

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58339

--- Comment #4 from Javen O'Neal  ---
Is there an ignored failing unit test to show that the offset function doesn't
work when one or both of the last two parameters are missing? If not, that's
probably all this bug needs before it can be merged.

-- 
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 46136] Add an ignore warning for cells with Numbers as Text

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=46136

--- Comment #6 from Nick Burch  ---
XSSF now has a suitable set of Usermodel methods, and there's a common enum of
the error types + support in FeatFormulaErr2

This now needs someone to implement those same methods (+add them to the
interface), by doing the necessary record finding/adding/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



[Bug 56892] [PATCH] Ignoring number-stored-as-text warnings requires going via CTWorksheet

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=56892

Nick Burch  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|NEEDINFO|RESOLVED

--- Comment #8 from Nick Burch  ---
As of r1730543, I've moved the enum into the main ss package, and documented
those entries that I can from the XLS spec. That leaves a couple needing
descriptions that I think are XLSX-only.

I haven't added the matching HSSF support using FeatFormulaErr2, that remains
for #46136

-- 
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 58339] [PATCH] Make OFFSET() accept missing parameters

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58339

--- Comment #3 from Patrick Zimmermann  ---
Is there anything I can do to get this merged or is it just missing tuits?

-- 
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: Adding utility method to check any protection is...

2016-02-15 Thread asfgit
Github user asfgit closed the pull request at:

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


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

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



[Bug 58838] Some cells are null when they aren't

2016-02-15 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58838

--- Comment #10 from Dominik Stadler  ---
initial attempt at a unit test for this:

@Test
public void testBug58838() throws IOException {
Workbook wb = HSSFTestDataSamples.openSampleWorkbook("58838.xls");

Sheet sheet = wb.getSheet("InitCharge");
Row row = sheet.getRow(1);

//int lastCol = CellReference.convertColStringToIndex("BC");
for (int c=0; c <= row.getLastCellNum(); c++) {
Cell cell = row.getCell(c);
if (cell != null) {
System.out.print(new CellReference(1, c).formatAsString() + ",
");
} else {
System.out.print("(" + new CellReference(1, c).formatAsString()
+ "), ");
}
}

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