[Bug 59170] Remove deprecated classes (POI 3.15)

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59170

--- Comment #5 from Javen O'Neal  ---
Removed o.a.p.hpsf.Constants in r1748480.
Removed o.a.p.hpsf.wellknown.SectionIDMap in r1748481.
Removed many deprecated methods and classes in r1748483.
Removed o.a.p.hwpf.model.PAPBinTable#writeTo in r1748488.
Removed o.a.p.xssf.usermodel.XSSFFontFormatting#getXSSFColor in r1748493.
Removed o.a.p.openxml4j.opc.Package in r1748494.
Removed o.a.p.xssf.extractor.XSSFExcelExtractor in r1748495.

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

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=57840

--- Comment #40 from Greg Woolsey  ---
(In reply to Javen O'Neal from comment #39)
Thanks.  I'm moving on to the Vaadin Spreadsheet side of things for my POC, as
the POI feature set and performance are acceptable at this stage.  I'll likely
file new issues/patches in the future if I get the project accepted.

I've submitted Vaadin bug https://dev.vaadin.com/ticket/19952 with a very
significant improvement to their current formula performance, especially
related to conditional formatting.

They were creating a new evaluation context for every _cell_ evaluated.  And to
do it, they were inserting a new row in an existing sheet, and modifying the
first cell's formula.  The row # is in the middle of the data for one of my
sample workbooks, and that whole scheme was an ugly hack.

I showed them how they could evaluate a formula without a Cell using an
existing WorkbookEvaluator, using code I found in the unit test framework. 
That, along with the cached results it could now leverage, took my sample
workbook from HOURS to marginally more time than the unit test I added to POI. 
I also have a patch to use POI 3.15 that I hope they take.  But that has more
in it, as they have some ugly code I couldn't bear to leave alone.  I want a
real-looking API along with the updated compatibility.

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

2016-06-14 Thread Javen O'Neal
That seems to be correct.

https://git.apache.org/poi.git and the github mirror at
https://github.com/apache/poi don't link to
https://svn.apache.org/repos/asf/poi/poi-site.

For now, Subversion is your best bet. I think there was some discussion
about moving the project to git, rather than having a read-only git mirror.
On Jun 14, 2016 7:22 PM, "Mark Murphy"  wrote:

> Trying to find documentation site on Git, but it does not appear to exist.
> Is this true?
>


Finding deprecated methods

2016-06-14 Thread Javen O'Neal
The @deprecated annotation on many methods and classes doesn't include a
version or date when deprecated or scheduled for removal.

Due to whitespace changes, looking at svn blame (show annotations in ViewVC
and Subclipse) doesn't necessarily show when the class or method was first
deprecated.

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?


Git

2016-06-14 Thread Mark Murphy
Trying to find documentation site on Git, but it does not appear to exist.
Is this true?


[Bug 57840] [PATCH] Support for structured references with Excel tables.

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=57840

Javen O'Neal  changed:

   What|Removed |Added

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

--- Comment #39 from Javen O'Neal  ---
(In reply to Greg Woolsey from comment #38)
> Perhaps we still need some comments as to why the explicit boxing is 
> happening,
> so they don't get undone?
Applied in r1748479.

I kept this bug open in case you had anything else you discovered from your
testing. I'll close it now.
These changes will be available in POI 3.15 beta 2, to be released in the next
couple months.

I'm assuming that general formula evaluation is faster as a whole with
r1747840, not just structured references.

In future bugs, we should look at:
 * comment 5: get Vaadin Spreadsheet working with POI versions higher than
3.12.
 * comment 12: When evaluating multiple formulas in a sheet, cache the formula
result of cells with the same expression
 * comment 21: add to POI documentation that "-XX:AutoBoxCacheMax=1048704" may
improve performance of working with large worksheets (perhaps this is no longer
true now that we're using explicit boxing).
 * comment 23: use HashMap instead of TreeMap to hold XSSFRows and XSSFCells in
XSSFSheet and XSSFRows, respectively. Obviously this would make moving rows or
getting all rows in a range extremely expensive.
 * comment 34: trigger a cache reset, either with an explicit public method or
implicitly with an internal method (this could make regular workbook operations
slower since any cell that is part of a table or any cell in a table that
references a value that changes in the workbook). Several methods in XSSFTable
still use caches that may contain stale data.
 * comment 38: continue to improve formula evaluation performance

-- 
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 57721] Evaluating formulas in named Excel table

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=57721
Bug 57721 depends on bug 57840, which changed state.

Bug 57840 Summary: [PATCH]  Support for structured references with Excel tables.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57840

   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



[Bug 59702] Slide master

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59702

--- Comment #3 from Andreas Beeker  ---
I've already fixed that issue locally, but now I try to make it more general,
so the setFillStyle/setFillColor works with table cells, group shapes,
backgrounds and of course normal shapes too.

I'll commit it in the next few days ..

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

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=57840

--- Comment #38 from Greg Woolsey  ---
Anything else needed I can help with before this issue is resolved?  Table
reference syntax works for all my samples, and performance is now vastly
improved (although still not where I think it should be, but that's a different
set of bugs and patches I'll file eventually).

The FindBugs issues have been addressed, as have unit tests.

Perhaps we still need some comments as to why the explicit boxing is happening,
so they don't get undone?

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



XWPF Lead

2016-06-14 Thread Mark Murphy
I have been researching the WordprocessingML spec, mostly because I have a
need to generate Word documents at work. I have noticed that there is a lot
of low hanging fruit in that API, and thought I would offer to take lead in
starting to get it into shape.

It appears that much of the code is there for Paragraphs and Runs, but
there is a lot of duplication of methods, and naming could be made more
consistent. Tables, headers and footers need more work. In fact it is
impossible to add a table to a header or footer without modifying the
API.Cleaning up these areas and creating documentation and tests would be
my initial focus. I don't think I will get a lot in before 3.15, but I
suspect with the amount of low hanging fruit, I could get a significant
dent made for 3.16.

Right now I have the Git repository cloned, and am starting to make changes
there. I will try to make changes compact enough to make reviews easy.


Re: 3.15 beta 2 soon?

2016-06-14 Thread Javen O'Neal
Mark Murphy,

How far out is CellStyleUtil? Do you want to try to get that into POI 3.15
beta 2 or aim for a later release?
On Jun 14, 2016 11:31 AM, "Javen O'Neal"  wrote:

> I exchanged GPG keys with several individuals at PyCon US a few weeks ago.
> I need to check if I'm in the Apache web of trust once all the signing is
> done. If I am, I will happily be release manager.
> On Jun 14, 2016 10:49, "Nick Burch"  wrote:
>
>> Hi All
>>
>> We're now about 2 months since we released 3.15-beta1, and it looks like
>> we've got quite a few fixes and bits of new behaviour in, which is great!
>> Based on bugzilla emails, we've also got a few user-contributed patches
>> which are almost ready/fully-applied too.
>>
>> So, two questions:
>>  - Can we have a volunteer to be Release Manager for 3.15 beta 2?
>>  - 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?
>>
>> Thanks
>> Nick
>>
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
>> For additional commands, e-mail: dev-h...@poi.apache.org
>>
>>


[Bug 59702] Slide master

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59702

--- Comment #2 from András Gábor Kis  ---
https://github.com/Frontrider/PowerPointGenerator

The github link to the project.

The location of the "error" is in hu.frontrider.pptgen.Writeppt.kt, line 48.

-- 
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 59702] Slide master

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59702

Javen O'Neal  changed:

   What|Removed |Added

 OS||All

--- Comment #1 from Javen O'Neal  ---
Could you be more specific about what's not working, such as a code example
demonstrating 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 59702] New: Slide master

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59702

Bug ID: 59702
   Summary: Slide master
   Product: POI
   Version: 3.14-FINAL
  Hardware: PC
Status: NEW
  Severity: blocker
  Priority: P2
 Component: XSLF
  Assignee: dev@poi.apache.org
  Reporter: kisandrasga...@gmail.com

The slide master doesn't seem to have a CTShapeProperties entry. The only thing
I tried to do is change the background color (currently i'm using a template
slide to permanently set it), but it will throw:
java.lang.IllegalStateException: CTShapeProperties was not found.

Theres a method to create one, but thats unimplemented.

I would really prefer not to use the messy whatever tool Microsoft has provided
for the task.

-- 
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: 3.15 beta 2 soon?

2016-06-14 Thread Javen O'Neal
I exchanged GPG keys with several individuals at PyCon US a few weeks ago.
I need to check if I'm in the Apache web of trust once all the signing is
done. If I am, I will happily be release manager.
On Jun 14, 2016 10:49, "Nick Burch"  wrote:

> Hi All
>
> We're now about 2 months since we released 3.15-beta1, and it looks like
> we've got quite a few fixes and bits of new behaviour in, which is great!
> Based on bugzilla emails, we've also got a few user-contributed patches
> which are almost ready/fully-applied too.
>
> So, two questions:
>  - Can we have a volunteer to be Release Manager for 3.15 beta 2?
>  - 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?
>
> Thanks
> Nick
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> For additional commands, e-mail: dev-h...@poi.apache.org
>
>


3.15 beta 2 soon?

2016-06-14 Thread Nick Burch

Hi All

We're now about 2 months since we released 3.15-beta1, and it looks like 
we've got quite a few fixes and bits of new behaviour in, which is great! 
Based on bugzilla emails, we've also got a few user-contributed patches 
which are almost ready/fully-applied too.


So, two questions:
 - Can we have a volunteer to be Release Manager for 3.15 beta 2?
 - 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?

Thanks
Nick

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



[Bug 59700] Ability to update header with an image using HWPF

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59700

Dominik Stadler  changed:

   What|Removed |Added

   Severity|normal  |enhancement
 OS||All

--- Comment #1 from Dominik Stadler  ---
Unfortunately if you didn't get responses on the other channels there is not
much chance of an immediate response here as mostly the same people watch the
issues here as well (even less as mostly only devs look at issues, so
forums/stackoverflow/mailinglists is usually a much better place to ask
questions)...

-- 
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 59700] New: Ability to update header with an image using HWPF

2016-06-14 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=59700

Bug ID: 59700
   Summary: Ability to update header with an image using HWPF
   Product: POI
   Version: 3.14-FINAL
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: HWPF
  Assignee: dev@poi.apache.org
  Reporter: nishant.noid...@gmail.com

I have a requirement to add image to header of a .doc file (97-2003 format). I
am contemplating use of HWPF for the same. While I could replace text in
header, i am unable to find a way to remove the current header and replace it
with an image file in header.
I tried to go through other resources and forums but got no resolution on this
using HWPF.
Please advise if its feasible using HWPFDocument.

Thanks

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