You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by Blake Watson <bl...@pnmac.com> on 2018/01/02 22:28:51 UTC

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

I dropped the JARs into my Maven directories which almost seemed to work,
but I'm getting ClassNotFoundException for org.apache.xmlbeans.XMLObject.

Maybe related to 59268
? I see the xmlbeans jar in the package but if I swap it out for the
existing xmlbeans-2.6.0.jar that doesn't seem to change anything.

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

Posted by Blake Watson <bl...@pnmac.com>.

Cool! Thanks, Greg!

On Tue, Jan 23, 2018 at 1:59 PM, Greg Woolsey <gr...@gmail.com>
wrote:

> Interesting!  I'd love to see that as Java to run some comparisons, but I
> don't have the time right now to investigate.  If you do it, I'd evaluate
> and commit it if appropriate.
>
> On Tue, Jan 23, 2018 at 1:32 PM Blake Watson <bl...@pnmac.com>
> wrote:
>
> > OK, FWIW, I did this:
> >
> > 1. I get all the rules on the sheet...
> > 2. ...and map the rules to their formatting...
> > 3. ...then call getMatchingCells for each rule...
> > 4. ...and create a map of cells to formatting...
> > 5. ...then merge the maps for all rules...
> >
> > I ended up with a hash-map of cell=>formatting that is much faster (20x)
> to
> > reference for each cell than calling .getConditionalForCell. (That's for
> > one 800 cell sheet on a smallish spreadsheet of about 70K with three
> simple
> > conditional formatting rules.)
> >
> > If I can Java-ize it, it might be worth putting into a utility unit.
> >
> > ===Blake===
> >
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

Posted by Greg Woolsey <gr...@gmail.com>.

Interesting!  I'd love to see that as Java to run some comparisons, but I
don't have the time right now to investigate.  If you do it, I'd evaluate
and commit it if appropriate.

On Tue, Jan 23, 2018 at 1:32 PM Blake Watson <bl...@pnmac.com> wrote:

> OK, FWIW, I did this:
>
> 1. I get all the rules on the sheet...
> 2. ...and map the rules to their formatting...
> 3. ...then call getMatchingCells for each rule...
> 4. ...and create a map of cells to formatting...
> 5. ...then merge the maps for all rules...
>
> I ended up with a hash-map of cell=>formatting that is much faster (20x) to
> reference for each cell than calling .getConditionalForCell. (That's for
> one 800 cell sheet on a smallish spreadsheet of about 70K with three simple
> conditional formatting rules.)
>
> If I can Java-ize it, it might be worth putting into a utility unit.
>
> ===Blake===
>

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

Posted by Blake Watson <bl...@pnmac.com>.

OK, FWIW, I did this:

1. I get all the rules on the sheet...
2. ...and map the rules to their formatting...
3. ...then call getMatchingCells for each rule...
4. ...and create a map of cells to formatting...
5. ...then merge the maps for all rules...

I ended up with a hash-map of cell=>formatting that is much faster (20x) to
reference for each cell than calling .getConditionalForCell. (That's for
one 800 cell sheet on a smallish spreadsheet of about 70K with three simple
conditional formatting rules.)

If I can Java-ize it, it might be worth putting into a utility unit.

===Blake===

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

Posted by Blake Watson <bl...@pnmac.com>.

OK. *Phew* Got it all working aaaand...it has no impact on the speed. So
I'm going to go back and see if I can't find the issue in the conditional
stuff.

On Wed, Jan 3, 2018 at 2:41 PM, Blake Watson <bl...@pnmac.com> wrote:

> Never mind. Found it. =)
>
> On Wed, Jan 3, 2018 at 2:34 PM, Blake Watson <bl...@pnmac.com>
> wrote:
>
>> The POM for 3.17 doesn't include XMLBeans or Commons-Collections4.
>>
>> What happened to CELL_TYPE_FORMULA? Is there a list of changes for 4?
>>
>> On Tue, Jan 2, 2018 at 9:44 PM, Blake Watson <bl...@pnmac.com>
>> wrote:
>>
>>> What's weird is, XMLBeans doesn't appear to be any different in the
>>> downloaded trunk. It's the exact same size as the one I've been using.
>>>
>>> On Tue, Jan 2, 2018 at 4:04 PM, Greg Woolsey <gr...@gmail.com>
>>> wrote:
>>>
>>>> I can barely function with Maven, so I'm no help on that front,
>>>> unfortunately.  I know folks have had various issues and questions about
>>>> XMLBeans and classpath issues on the mailing list and StackOverflow,
>>>> though, so you may find some answers in those archives.
>>>>
>>>> On Tue, Jan 2, 2018 at 2:29 PM Blake Watson <bl...@pnmac.com>
>>>> wrote:
>>>>
>>>> > I dropped the JARs into my Maven directories which almost seemed to
>>>> work,
>>>> > but I'm getting ClassNotFoundException for
>>>> org.apache.xmlbeans.XMLObject.
>>>> >
>>>> > Maybe related to 59268
>>>> > ? I see the xmlbeans jar in the package but if I swap it out for the
>>>> > existing xmlbeans-2.6.0.jar that doesn't seem to change anything.
>>>> >
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> *Blake Watson*
>>>
>>> *PNMAC*
>>> Application Development Manager
>>> 5898 Condor Drive
>>> Moorpark, CA 93021
>>> (805) 330.4911 x7742
>>> blake.watson@pnmac.com
>>> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>>>
>>
>>
>>
>> --
>>
>> *Blake Watson*
>>
>> *PNMAC*
>> Application Development Manager
>> 5898 Condor Drive
>> Moorpark, CA 93021
>> (805) 330.4911 x7742
>> blake.watson@pnmac.com
>> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>>
>
>
>
> --
>
> *Blake Watson*
>
> *PNMAC*
> Application Development Manager
> 5898 Condor Drive
> Moorpark, CA 93021
> (805) 330.4911 x7742
> blake.watson@pnmac.com
> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

Posted by Blake Watson <bl...@pnmac.com>.

Never mind. Found it. =)

On Wed, Jan 3, 2018 at 2:34 PM, Blake Watson <bl...@pnmac.com> wrote:

> The POM for 3.17 doesn't include XMLBeans or Commons-Collections4.
>
> What happened to CELL_TYPE_FORMULA? Is there a list of changes for 4?
>
> On Tue, Jan 2, 2018 at 9:44 PM, Blake Watson <bl...@pnmac.com>
> wrote:
>
>> What's weird is, XMLBeans doesn't appear to be any different in the
>> downloaded trunk. It's the exact same size as the one I've been using.
>>
>> On Tue, Jan 2, 2018 at 4:04 PM, Greg Woolsey <gr...@gmail.com>
>> wrote:
>>
>>> I can barely function with Maven, so I'm no help on that front,
>>> unfortunately.  I know folks have had various issues and questions about
>>> XMLBeans and classpath issues on the mailing list and StackOverflow,
>>> though, so you may find some answers in those archives.
>>>
>>> On Tue, Jan 2, 2018 at 2:29 PM Blake Watson <bl...@pnmac.com>
>>> wrote:
>>>
>>> > I dropped the JARs into my Maven directories which almost seemed to
>>> work,
>>> > but I'm getting ClassNotFoundException for
>>> org.apache.xmlbeans.XMLObject.
>>> >
>>> > Maybe related to 59268
>>> > ? I see the xmlbeans jar in the package but if I swap it out for the
>>> > existing xmlbeans-2.6.0.jar that doesn't seem to change anything.
>>> >
>>>
>>
>>
>>
>> --
>>
>> *Blake Watson*
>>
>> *PNMAC*
>> Application Development Manager
>> 5898 Condor Drive
>> Moorpark, CA 93021
>> (805) 330.4911 x7742
>> blake.watson@pnmac.com
>> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>>
>
>
>
> --
>
> *Blake Watson*
>
> *PNMAC*
> Application Development Manager
> 5898 Condor Drive
> Moorpark, CA 93021
> (805) 330.4911 x7742
> blake.watson@pnmac.com
> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

Posted by Blake Watson <bl...@pnmac.com>.

The POM for 3.17 doesn't include XMLBeans or Commons-Collections4.

What happened to CELL_TYPE_FORMULA? Is there a list of changes for 4?

On Tue, Jan 2, 2018 at 9:44 PM, Blake Watson <bl...@pnmac.com> wrote:

> What's weird is, XMLBeans doesn't appear to be any different in the
> downloaded trunk. It's the exact same size as the one I've been using.
>
> On Tue, Jan 2, 2018 at 4:04 PM, Greg Woolsey <gr...@gmail.com>
> wrote:
>
>> I can barely function with Maven, so I'm no help on that front,
>> unfortunately.  I know folks have had various issues and questions about
>> XMLBeans and classpath issues on the mailing list and StackOverflow,
>> though, so you may find some answers in those archives.
>>
>> On Tue, Jan 2, 2018 at 2:29 PM Blake Watson <bl...@pnmac.com>
>> wrote:
>>
>> > I dropped the JARs into my Maven directories which almost seemed to
>> work,
>> > but I'm getting ClassNotFoundException for
>> org.apache.xmlbeans.XMLObject.
>> >
>> > Maybe related to 59268
>> > ? I see the xmlbeans jar in the package but if I swap it out for the
>> > existing xmlbeans-2.6.0.jar that doesn't seem to change anything.
>> >
>>
>
>
>
> --
>
> *Blake Watson*
>
> *PNMAC*
> Application Development Manager
> 5898 Condor Drive
> Moorpark, CA 93021
> (805) 330.4911 x7742
> blake.watson@pnmac.com
> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

Posted by Blake Watson <bl...@pnmac.com>.

What's weird is, XMLBeans doesn't appear to be any different in the
downloaded trunk. It's the exact same size as the one I've been using.

On Tue, Jan 2, 2018 at 4:04 PM, Greg Woolsey <gr...@gmail.com> wrote:

> I can barely function with Maven, so I'm no help on that front,
> unfortunately.  I know folks have had various issues and questions about
> XMLBeans and classpath issues on the mailing list and StackOverflow,
> though, so you may find some answers in those archives.
>
> On Tue, Jan 2, 2018 at 2:29 PM Blake Watson <bl...@pnmac.com>
> wrote:
>
> > I dropped the JARs into my Maven directories which almost seemed to work,
> > but I'm getting ClassNotFoundException for org.apache.xmlbeans.XMLObject.
> >
> > Maybe related to 59268
> > ? I see the xmlbeans jar in the package but if I swap it out for the
> > existing xmlbeans-2.6.0.jar that doesn't seem to change anything.
> >
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Re: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?

Posted by Greg Woolsey <gr...@gmail.com>.

I can barely function with Maven, so I'm no help on that front,
unfortunately.  I know folks have had various issues and questions about
XMLBeans and classpath issues on the mailing list and StackOverflow,
though, so you may find some answers in those archives.

On Tue, Jan 2, 2018 at 2:29 PM Blake Watson <bl...@pnmac.com> wrote:

> I dropped the JARs into my Maven directories which almost seemed to work,
> but I'm getting ClassNotFoundException for org.apache.xmlbeans.XMLObject.
>
> Maybe related to 59268
> ? I see the xmlbeans jar in the package but if I swap it out for the
> existing xmlbeans-2.6.0.jar that doesn't seem to change anything.
>