Hi Dominik,
i used -XX:+UseG1GC -XX:+UseStringDeduplication -Xmx1024m for the (java 8)
vm and used VisualVM for monitoring. *used* heap was 750m reserved somehow
1.5g.
Jan
2016-12-19 21:49 GMT+01:00 Dominik Stadler :
> Hi,
>
> How did you measure the memory consumption? Did you set -Xmx?
Looks like Microsoft suggests [1] conditional formatting or a data table
(XSSFTable), so you were on the right track to solve this with POI's
conditional formatting.
Either way, it sounds like we should cover this somewhat common scenario
either in poi-examples or the spreadsheet quick guide. Pull
BTW, if you look at the quick guide
https://poi.apache.org/spreadsheet/quick-guide.html#CellProperties you will
find two methods of drawing borders without creating all those unused
intermediate styles.
On Mon, Dec 19, 2016 at 4:04 PM, Eric Douglas
wrote:
> Yeah, I wouldn't expect really fast re
I am pretty sure this is the way it works in Excel. Conditional formatting
overrides the stated cell style. In order to get any other colors you need to
add additional rules to the conditional formatting.
-Original Message-
From: Eric Douglas [mailto:edoug...@blockhouse.com]
Sent: Monda
I can take a stab at one of these.
#1) Why does Conditional formatting use setBackgroundColor to set the fill
color for Solid Fill while styles use setForgroundColor?
I noticed this discrepancy myself. To answer the question I generated a simple
spreadsheet in MS Excel with one cell colored vi
Yeah, I wouldn't expect really fast response from a list like this. My
previous message was 6 days ago.
I didn't see an easy way to get alternate row styling with regular styles
(to color only even numbered rows, and keep only even numbered rows colored
if the user sorts by a different column) but
Hi,
How did you measure the memory consumption? Did you set -Xmx? Because if
not having -Xmx, Java will use some default based on overall available
memory and with a high amount of available memory, GC will not run and thus
lots of memory may be reported as "used", but actually just not freed
yet.
I think there's a way to apply alternate row styling within regular styles
(not conditional formatting), but have never used POI to do this. Rather
than tell you the wrong answer, I'd rather stay quiet to avoid unnecessary
confusion. Read through the OOXML schemas or create a file in Excel with
alt
How many POI developers actively monitor this list? I haven't gotten any
answers to those questions.
Meanwhile I have a new question. If I create a conditional formatting
which is linked to the entire document and colors every other row, how can
I get individual colors in cell styles to override
Hi,
this is my firtst mail to a mailing list.
I asumed that just copy via streaming would consume only little memory. Why
do i get 750m ram consumption for a 12m file?
Is there any way to replace a Sheet in a Workbook without consuming tons of
memory?
try (OPCPackage pkg = OPCPackage.ope
10 matches
Mail list logo
