[Bug 57598] No way to associate shape with its textbox text range

[bugzilla]

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

--- Comment #2 from sbub...@gmail.com ---
This was 14 months ago when I was still working at my last job (and cared about
this issue).  I may forgtoten something.  If I remember correctly there was an
API method/class that returned all the shapes' text as one big range/block
text.  All shape's texts were terminated by new lines (and I think in order
from top to bottom).  Which may have been extremely helpful except shapes
(especially comments which I think were also in there) can multiple lines over
their own.  Now there is no reliable way to know when one shape ends and the
next begins using this blob.  What would have been more helpful is if each
diagram/shape knew its own text and exposed it via its own API rather then
putting all shaepe text in one big blob.  Of if you want keep the blob, the
shape could known it's own text offset and length in the blob.

We were trying to find all text in documents, no matter if paragraph, shape,
whatever and order them to something resembling to top to bottom.  We tried all
an API method until we discovered API was lacking things we needed so did most
of the work in the OOXML itself and found a solution tht fit our needs.

-- 
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 58787] [patch] Border utility to set cell styles around a range of cells

[bugzilla]

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

--- Comment #24 from Javen O'Neal  ---
Update this documentation as well: https://poi.apache.org/faq.html#faq-N100E3

-- 
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 57596] OfficeDrawing doesn't return diagram escher records

[bugzilla]

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

--- Comment #2 from sbub...@gmail.com ---
(In reply to Dominik Stadler from comment #1)
> Can you attach a sample file and code that you tried? Idealy as
> self-sufficient unit-test.

This was 14 months ago when I was still working at my last job (and cared about
this issues).  I have forgooten the exact details.  In either getting the
diagram from OfficeDiagrams or getting the picture data or something, it would
only allow diagram whose parents where SPContainers.  But that doesn't apply to
SmartArt so whichever method was returned NULL.

We were trying to find all text in documents, no matter if paragraph, shape,
whatever and order them to something resembling to top to bottom.  We tried all
an API method until we discovered API was lacking things we needed so did most
of the work in the OOXML itself and found a solution tht fit our needs.

-- 
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 55555] Adding a border to a cell with background pattern sets the pattern color to black

[bugzilla]

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

--- Comment #11 from Javen O'Neal  ---
Gilles,

Any chance you could trim your Excel files and Java test code down to the bare
minimum needed to reproduce the problem? It would make diffing the Excel files
easier to figure out what's going on.

If not, this bug will probably get closed as not reproducible.

-- 
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 #3 from Javen O'Neal  ---
Created attachment 33730
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33730=edit
Javadocs fixes for XSSFFont

-- 
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 #2 from Javen O'Neal  ---
Looking at XSSFFont.setBoldweight(short boldweight), it looks like
getBoldweight and setBoldweight were never intended to be used with
literals--only the Font.BOLDWEIGHT_NORMAL and Font.BOLDWEIGHT_BOLD constants.
[1]

Your example can be simplified to:
Workbook wb = new XSSFWorkbook();
Font font = wb.createFont();
short weight = 314;
assumeTrue(weight != Font.BOLDWEIGHT_NORMAL);
assumeTrue(weight != Font.BOLDWEIGHT_BOLD);
font.setBoldweight(weight);
assertEquals(weight, font.getBoldweight);

The XSSFFont never stores the requested boldweight.
If the OOXML format allows specifying a numeric weight in addition to a boolean
bold/not-bold value, then this is a bug in POI.

>From what I can make out in the 2006 OOXML schema, custom font weights are not
part of the standard.

sml-styles.xsd:
  

  ...
  

  Bold

  
  ...

  

A note should be added to XSSFFont.get/setBoldweight javadocs that only the
named constants will work.

[1]
https://svn.apache.org/viewvc/poi/trunk/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFFont.java?revision=1701134=markup#l300

-- 
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 58563] XSSFRichTextString does not implement equals, but HSSFRichTextString does

[bugzilla]

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

--- Comment #3 from Javen O'Neal  ---
Shouldn't H/XSSFRichTextString equals method be a rich text compare? If the
user wants plain text compare, they can always do
H/XSSFRichTextString.getString().equals.

-- 
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 55341] [PATCH] constants for HAIR and DOTTED border styles are swapped

[bugzilla]

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

--- Comment #5 from Javen O'Neal  ---
Vlad,

Could you verify that bug 59264 does not introduce a regression?

org.apache.poi.ss.usermodel.BorderStyles.HAIR and DOTTED are now the single
entry-points for setting and getting hairline and dotted cell borders.

-- 
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 59264] Unify interface for setting cell border line styles using BorderStyle enum instead of short code

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

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

--- Comment #5 from Javen O'Neal  ---
Updated JavaDocs in r1737894. These changes will be available in POI 3.15 beta
2.

Updated change log in r1737888.

-- 
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 58787] [patch] Border utility to set cell styles around a range of cells

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=58787
Bug 58787 depends on bug 59264, which changed state.

Bug 59264 Summary: Unify interface for setting cell border line styles using 
BorderStyle enum instead of short code
https://bz.apache.org/bugzilla/show_bug.cgi?id=59264

   What|Removed |Added

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

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

[Javen O'Neal]

58787 is not ready for beta 1. I assumed that since the release tag has
already been created for beta 1 that trunk is open for beta 2 commits.

If trunk is not open or we need to create a beta 1 RC 2, some svn merging
will be needed to exclude these post-beta1 commits.
On Apr 5, 2016 4:05 PM, "Andreas Beeker"  wrote:

> Hi All,
>
> There are already checkins for beta2 ... how about postponing this
> justification to beta2?
>
> I had a discussion with Dominik about what to include in the beta1 and
> if I should wait for #58787 to be finished.
> As we had some extensive testing for the trunk and #58787 seems to be a
> bit elaborate,
> I would like to also postpone it to beta2.
>
> Is this ok for you?
>
> Andi
>
> On 05.04.2016 08:47, Javen O'Neal wrote:
> > Also, do we need to add bouncy castle, jaxb, or any other 3rd party libs
> to
> > our LICENSE or NOTICE file?
> >
> > https://svn.apache.org/viewvc/poi/trunk/legal/NOTICE?view=markup
> > On Apr 4, 2016 11:44 PM, "Javen O'Neal"  wrote:
> >
> >> Looks like our LICENSE [1] file still references ooxml-schemas-1.1, when
> >> we're currently on 1.3 [2]. Are any other changes needed besides
> >> incrementing the number?
> >>
> >> [1] https://svn.apache.org/viewvc/poi/trunk/legal/LICENSE?view=log
> >> [2]
> >>
> https://builds.apache.org/job/POI/lastSuccessfulBuild/artifact/ooxml-lib/
> >>
>
>
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> For additional commands, e-mail: dev-h...@poi.apache.org
>
>

Re: License

[Andreas Beeker]

Hi All,

There are already checkins for beta2 ... how about postponing this 
justification to beta2?

I had a discussion with Dominik about what to include in the beta1 and
if I should wait for #58787 to be finished.
As we had some extensive testing for the trunk and #58787 seems to be a bit 
elaborate,
I would like to also postpone it to beta2.

Is this ok for you?

Andi

On 05.04.2016 08:47, Javen O'Neal wrote:
> Also, do we need to add bouncy castle, jaxb, or any other 3rd party libs to
> our LICENSE or NOTICE file?
>
> https://svn.apache.org/viewvc/poi/trunk/legal/NOTICE?view=markup
> On Apr 4, 2016 11:44 PM, "Javen O'Neal"  wrote:
>
>> Looks like our LICENSE [1] file still references ooxml-schemas-1.1, when
>> we're currently on 1.3 [2]. Are any other changes needed besides
>> incrementing the number?
>>
>> [1] https://svn.apache.org/viewvc/poi/trunk/legal/LICENSE?view=log
>> [2]
>> https://builds.apache.org/job/POI/lastSuccessfulBuild/artifact/ooxml-lib/
>>



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

[Bug 59264] Unify interface for setting cell border line styles using BorderStyle enum instead of short code

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

Summary|Change CellStyle border |Unify interface for setting
   |style constants from short  |cell border line styles
   |to enum |using BorderStyle enum
   ||instead of short code

-- 
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 59264] Change CellStyle border style constants from short to enum

[bugzilla]

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

--- Comment #4 from Javen O'Neal  ---
Implemented in r1737751, r1737752, r1737879, r1737884, r1737885, r1737886

Backwards-incompatible changes:
* Change: BorderStyle.MEDIUM_DASH_DOT_DOTC renamed to MEDIUM_DASH_DOT_DOT
  Affected classes:
o.a.p.ss.usermodel.BorderStyle
* Change: getBorderX returns BorderStyle instead of short.
  Affected classes:
o.a.p.hssf.usermodel.HSSFBorderFormatting
o.a.p.hssf.usermodel.HSSFCellStyle
o.a.p.ss.usermodel.BorderFormatting
o.a.p.ss.usermodel.BorderStyle
o.a.p.ss.usermodel.CellStyle
o.a.p.xssf.usermodel.XSSFBorderFormatting
o.a.p.xssf.usermodel.XSSFCellStyle

Deprecated features (will be removed in a future release):
* Change: short BORDER_* constants deprecated. Use BorderStyle enum values
instead.
  Affected classes:
o.a.p.ss.usermodel.BorderFormatting
o.a.p.ss.usermodel.CellStyle
* Change: setBorderX(short) deprecated. Use setBorderX(BorderStyle) instead.
  Affected classes:
o.a.p.hssf.usermodel.HSSFBorderFormatting
o.a.p.hssf.usermodel.HSSFCellStyle
o.a.p.ss.usermodel.BorderFormatting
o.a.p.ss.usermodel.BorderStyle
o.a.p.ss.usermodel.CellStyle
o.a.p.xssf.usermodel.XSSFBorderFormatting
o.a.p.xssf.usermodel.XSSFCellStyle
* Change: getBorderLeftEnum deprecated. Use getBorderLeft instead.
  Affected classes:
o.a.p.xssf.usermodel.XSSFCellStyle
* Change: CellUtil.getFormatProperties/setFormatProperties operate on
BorderStyle enums instead of shorts for border line styles
  Affected classes:
o.a.p.ss.util.CellUtil
  Side-note: This deprecation warning is inside a private method. How do I
alert developers that setting BorderStyles with short/Short will be deprecated
besides raising an runtime ClassCastException when BorderStyles become
required?

Per comment 1, BaseTestBorderStyle [1] tests to make sure that HAIR and DOTTED
enums are as expected. HAIR is smaller dots than DOTTED. Anyone wondering what
each border style looks like can open test-data/spreadsheet/59264.xls or
59264.xlsx.

[1]
https://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestBorderStyle.java?view=markup=1737879

-- 
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 54593] Poor performance when adding borders

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Depends on||58787

--- Comment #6 from Javen O'Neal  ---
Bug 58787 might solve some of these efficiency problems, since styles are built
up in a standalone data structure then applied in one go, creating fewer
intermediate styles and searching through the styles table for matching styles
fewer times (setCellStyleProperties).

-- 
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 58787] [patch] Border utility to set cell styles around a range of cells

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Blocks||54593

-- 
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 55007] Add function to indirectly reference formulas

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |INVALID

--- Comment #2 from Javen O'Neal  ---
How does Excel handle a workbook saved by OO Calc with "function pointers"?

If it's not in the BIFF or OOXML spreadsheet specs, it would be difficult to
implement this in a cross-application compatible way.

Closing due to no progress in several years. If this functionality is still
needed, please reopen, provide a workbook with "function pointers" saved by OO
Calc, and a patch that implements this behavior in POI in a
standards-compatible way.

-- 
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 51083] Issue with VBA Macro in Excel 2003/2007

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

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

--- Comment #4 from Javen O'Neal  ---
No progress in several years. Please reopen if you can provide a patch.

I don't have access to the older versions of Excel, so I cannot test this. It
may be a bug in the Excel application itself. Either way, it would be difficult
to test this or prove that POI does or does not create a valid file because the
BIFF format is not an open specification like OOXML.

Try using the latest version of POI (3.14), which may include fixes that solve
your 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 48404] Support formulas with multi-sheet 3D references

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

   Severity|major   |enhancement
Summary|in getting 3-D formula  |Support formulas with
   |gives 2-D formula   |multi-sheet 3D references

--- Comment #3 from Javen O'Neal  ---
As of POI 3.14, POI still does not support multi-sheet 3D references. If you
still need this or found a solution, please submit a patch with a working 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

[Bug 57651] Not able to use a Excel 97 file as template when it containes used User-Define Functions

[bugzilla]

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

--- Comment #4 from v.tho...@alkaes.fr ---
Thanks for your return.
The initial need has been aborted due to the initial bug.
I will have an improvement to develop in few weeks ... I will try to re-test
it.

V.

-- 
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 57161] Add a warning against opening Excel file with WorkbookFactory.create(File)

[bugzilla]

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

Javen O'Neal  changed:

   What|Removed |Added

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

--- Comment #1 from Javen O'Neal  ---
This will be addressed in bug 58779, either as a documentation update or a
change in behavior to workbook.close().

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

-- 
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 58648] FormulaParser throws exception in parseSimpleFactor() when getCellFormula() is called on a cell and the formula contains spaces between closing parentheses ") )"

[bugzilla]

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

--- Comment #12 from Javen O'Neal  ---
Intersection is whitespace between two cell range/area PTGs. If the two
operands don't evaluate to ranges, treat the whitespace as just whitespace. Is
multiple whitespace characters as the operator a valid intersection expression?

-- 
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 56911] PlfLfo.add(LFO, LFOData) results in IOOBE

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|WORKSFORME  |---

--- Comment #2 from Dominik Stadler  ---
Oops, sorry, I was wrong, seems to be really broken, but not used anywhere at
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 57062] poi cannot read date is when first column is empty and second column in date

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Depends on||56702

-- 
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 56702] Get one exception "java.lang.IllegalStateException: Cannot get a numeric value from a text cell" when calling org.apache.poi.ss.usermodel.DataFormatter.formatCellValue

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Blocks||57062

-- 
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 57161] Add a warning against opening Excel file with WorkbookFactory.create(File)

[bugzilla]

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

Dominik Stadler  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 58648] FormulaParser throws exception in parseSimpleFactor() when getCellFormula() is called on a cell and the formula contains spaces between closing parentheses ") )"

[bugzilla]

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

--- Comment #11 from Kai G  ---
That makes sense. Unfortunately I don't know the whole formula parsing in POI
too well, so I don't know if your suggested fix would work ;-(

-- 
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-JDK8 #921

[Apache Jenkins Server]

See 


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

[Bug 57352] NPE in org.apache.poi.hsmf.extractor.OutlookTextExtactor

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|INVALID |---

--- Comment #5 from Dominik Stadler  ---
Sorry, wrong bug, reopened this again as the fix would be fairly simple here.

-- 
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 57352] NPE in org.apache.poi.hsmf.extractor.OutlookTextExtactor

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

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

--- Comment #4 from Dominik Stadler  ---
No response for a long time, therefore I think there is not much that we can do
for now, please reopen with more information if you still have this 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 57366] XWPFTable to Header / Footer

[bugzilla]

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

Dominik Stadler  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 57596] OfficeDrawing doesn't return diagram escher records

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from Dominik Stadler  ---
Can you attach a sample file and code that you tried? Idealy as self-sufficient
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

[Bug 57598] No way to associate shape with its textbox text range

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from Dominik Stadler  ---
Can you attach a sample file that can be used for looking at 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 57651] Not able to use a Excel 97 file as template when it containes used User-Define Functions

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

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

--- Comment #2 from Dominik Stadler  ---
No answer on the questions for a long time, thus i am closing this until we get
the required information. Feel free to reopen if you can provide more
information.

-- 
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 57667] Splitting PPTx in to Individual Slides Not Working.

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from Dominik Stadler  ---
Can you attach a sample file and some self-sufficient piece of code that
reproduces this 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 59050] Unable to create SXSSF work book in unix environment with JBOSS dev studio 4.0

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

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

--- Comment #7 from Dominik Stadler  ---
Please reopen this bug when you can attach sample documents here, otherwise
there is not much we can do...

-- 
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 59061] How to create PPTX using power-point-template file

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

Version|3.13-FINAL  |3.14-FINAL

-- 
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 59273] Unable to create pptx file by potx file using Apache POI

[bugzilla]

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

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

Re: License

[Nick Burch]

On Mon, 4 Apr 2016, Javen O'Neal wrote:

Also, do we need to add bouncy castle, jaxb, or any other 3rd party libs to
our LICENSE or NOTICE file?


Depends on the license that they're under

Best resources for looking up what needs what is a mixture of 
http://www.apache.org/legal/resolved.html and the general@incubator 
mailing list / list archives


Nick

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

[Apache Jenkins Server]

See 


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

[Bug 59273] New: Unable to create pptx file by potx file using Apache POI

[bugzilla]

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

Bug ID: 59273
   Summary: Unable to create pptx file by potx file using Apache
POI
   Product: POI
   Version: 3.13-FINAL
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: XSLF
  Assignee: dev@poi.apache.org
  Reporter: rahul.kr.sharm...@gmail.com

Created attachment 33728
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33728=edit
Potx file by which I want to create pptx.

Hi I am trying to create power-point presentation(pptx) file with potx power
point presentation template using Apache POI. The file was generated but giving
error "The File format or File extension is not valid Verify that the file has
not been corrupted and that the file extension matches the format of the file."
when trying to open it up . I am using below code Kindly see what I am doing
wrong.


public static void createPPTXWithPOTX() throws Exception
 {

File potx_File = new File(System.getProperty("user.dir") +
"/src/resources/Examples/SelfMadePOTX.potx");

File pptx_File = new File(System.getProperty("user.dir") +
"/src/resources/Examples/PPTWithTemplate12.pptx");

FileInputStream ins = new FileInputStream(potx_File);
FileOutputStream out = new FileOutputStream(pptx_File);
XMLSlideShow ppt = new XMLSlideShow(ins);
// first see what slide layouts are available :
System.out.println("Available slide layouts:");
for (XSLFSlideMaster master : ppt.getSlideMasters()) {
for (XSLFSlideLayout layout : master.getSlideLayouts()) {
System.out.println(layout.getType());
}
}

// blank slide
XSLFSlide blankSlide = ppt.createSlide();
// there can be multiple masters each referencing a number of layouts
// for demonstration purposes we use the first (default) slide master
XSLFSlideMaster defaultMaster = ppt.getSlideMasters()[0];
// title slide
XSLFSlideLayout titleLayout =
defaultMaster.getLayout(SlideLayout.TITLE);
// fill the placeholders
XSLFSlide slide1 = ppt.createSlide(titleLayout);
XSLFTextShape title1 = slide1.getPlaceholder(0);
title1.setText("First Title");

// title and content
XSLFSlideLayout titleBodyLayout =
defaultMaster.getLayout(SlideLayout.TITLE_AND_CONTENT);
XSLFSlide slide2 = ppt.createSlide(titleBodyLayout);

XSLFTextShape title2 = slide2.getPlaceholder(0);
title2.setText("Second Title");

XSLFTextShape body2 = slide2.getPlaceholder(1);
body2.clearText(); // unset any existing text
body2.addNewTextParagraph().addNewTextRun().setText("First paragraph");
body2.addNewTextParagraph().addNewTextRun().setText("Second
paragraph");
body2.addNewTextParagraph().addNewTextRun().setText("Third paragraph");

ppt.write(out);
}

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

Build failed in Jenkins: POI-JDK8 #920

[Apache Jenkins Server]

See 

Changes:

[centic] Add FAQ about multi-threaded access

--
[...truncated 2418 lines...]
[junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.393 sec
[junit] Running org.apache.poi.xssf.extractor.TestXSSFImportFromXML
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.153 sec
[junit] Running org.apache.poi.xssf.io.TestLoadSaveXSSF
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.045 sec
[junit] Running org.apache.poi.xssf.model.TestCalculationChain
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.458 sec
[junit] Running org.apache.poi.xssf.model.TestCommentsTable
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 0.153 sec
[junit] Running org.apache.poi.xssf.model.TestExternalLinksTable
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.079 sec
[junit] Running org.apache.poi.xssf.model.TestMapInfo
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.008 sec
[junit] Running org.apache.poi.xssf.model.TestSharedStringsTable
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.073 sec
[junit] Running org.apache.poi.xssf.model.TestStylesTable
[junit] Tests run: 11, Failures: 0, Errors: 0, Time elapsed: 0.179 sec
[junit] Running org.apache.poi.xssf.model.TestThemesTable
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.091 sec
[junit] Running org.apache.poi.xssf.streaming.TestAutoSizeColumnTracker
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 0.064 sec
[junit] Running org.apache.poi.xssf.streaming.TestOutlining
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.074 sec
[junit] Running org.apache.poi.xssf.streaming.TestSXSSFCell
[junit] Tests run: 30, Failures: 0, Errors: 0, Time elapsed: 0.365 sec
[junit] Running org.apache.poi.xssf.streaming.TestSXSSFDataValidation
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.184 sec
[junit] Running org.apache.poi.xssf.streaming.TestSXSSFFormulaEvaluation
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.038 sec
[junit] Running org.apache.poi.xssf.streaming.TestSXSSFHyperlink
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.021 sec
[junit] Running org.apache.poi.xssf.streaming.TestSXSSFRow
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.13 sec
[junit] Running org.apache.poi.xssf.streaming.TestSXSSFSheet
[junit] Tests run: 45, Failures: 0, Errors: 0, Time elapsed: 1.985 sec
[junit] Running org.apache.poi.xssf.streaming.TestSXSSFSheetAutoSizeColumn
[junit] Tests run: 26, Failures: 0, Errors: 0, Time elapsed: 0.575 sec
[junit] Running org.apache.poi.xssf.streaming.TestSXSSFWorkbook
[junit] Tests run: 30, Failures: 0, Errors: 0, Time elapsed: 1.035 sec
[junit] Running org.apache.poi.xssf.usermodel.TestFormulaEvaluatorOnXSSF
[junit] Tests run: 369, Failures: 0, Errors: 0, Time elapsed: 4.382 sec
[junit] Running org.apache.poi.xssf.usermodel.TestMissingWorkbookOnXSSF
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.049 sec
[junit] Running 
org.apache.poi.xssf.usermodel.TestMultiSheetFormulaEvaluatorOnXSSF
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.01 sec
[junit] Running org.apache.poi.xssf.usermodel.TestSXSSFBugs
[junit] Tests run: 25, Failures: 0, Errors: 0, Time elapsed: 7.479 sec
[junit] Running org.apache.poi.xssf.usermodel.TestSheetHiding
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.137 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFBugs
[junit] Tests run: 116, Failures: 0, Errors: 0, Time elapsed: 17.733 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFCell
[junit] Tests run: 49, Failures: 0, Errors: 0, Time elapsed: 0.872 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFCellStyle
[junit] Tests run: 41, Failures: 0, Errors: 0, Time elapsed: 0.411 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFChart
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.081 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFChartSheet
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.027 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFColGrouping
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.068 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFColor
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.046 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFComment
[junit] Tests run: 13, Failures: 0, Errors: 0, Time elapsed: 0.186 sec
[junit] Running org.apache.poi.xssf.usermodel.TestXSSFConditionalFormatting
[junit] Tests run: 17, Failures: 0, Errors: 0, Time elapsed: 0.177 sec
[junit] Running 

[Bug 58648] FormulaParser throws exception in parseSimpleFactor() when getCellFormula() is called on a cell and the formula contains spaces between closing parentheses ") )"

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Depends on||52111

--- Comment #10 from Dominik Stadler  ---
Seems to have been introduced by bug 52111 when support for the intersection
operator was added.

-- 
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 52111] [PATCH] Parsing of formula with reference intersection

[bugzilla]

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

Dominik Stadler  changed:

   What|Removed |Added

 Blocks||58648

-- 
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 58648] FormulaParser throws exception in parseSimpleFactor() when getCellFormula() is called on a cell and the formula contains spaces between closing parentheses ") )"

[bugzilla]

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

--- Comment #9 from Kai G  ---
Wow using a blank as an operator is really weird - I was not aware of that. Did
we add support for the intersection in 3.13 or what changes between 3.12 & 3.13
caused this issue?

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

[Javen O'Neal]

Also, do we need to add bouncy castle, jaxb, or any other 3rd party libs to
our LICENSE or NOTICE file?

https://svn.apache.org/viewvc/poi/trunk/legal/NOTICE?view=markup
On Apr 4, 2016 11:44 PM, "Javen O'Neal"  wrote:

> Looks like our LICENSE [1] file still references ooxml-schemas-1.1, when
> we're currently on 1.3 [2]. Are any other changes needed besides
> incrementing the number?
>
> [1] https://svn.apache.org/viewvc/poi/trunk/legal/LICENSE?view=log
> [2]
> https://builds.apache.org/job/POI/lastSuccessfulBuild/artifact/ooxml-lib/
>

License

[Javen O'Neal]

Looks like our LICENSE [1] file still references ooxml-schemas-1.1, when
we're currently on 1.3 [2]. Are any other changes needed besides
incrementing the number?

[1] https://svn.apache.org/viewvc/poi/trunk/legal/LICENSE?view=log
[2]
https://builds.apache.org/job/POI/lastSuccessfulBuild/artifact/ooxml-lib/