27;s the preferred fix for this? I'm thinking of something
along the lines of setting workbook formula evaluation mode from
automatic to manual mode. If manual mode is set, setCellFormula will
not call parseFormula.
Javen O'Neal
This problem isn't limited to just fill and border cell styles, but
cell styles in general. I have a similar problem when creating a
workbook with many (identical) styles
Along the same note, creating a new workbook, then calling:
for (int i=0; i<1000; i++) {
wb.createCellStyle()
}
And saving t
zilla/show_bug.cgi?id=58348).
Javen O'Neal
On Wed, Sep 23, 2015 at 5:59 AM, Murphy, Mark wrote:
> POI 3.12 - Windows - IBM JVM
>
> Here is some code (CopyRow is my own concoction based on some code I found on
> StackOverflow):
>
> try {
>
Please check out the patch I have in the queue for bug 58348 comment 4 [1].
I don't think my implementation copies data validation or conditional
formating, but this would be the place to add it.
[1]
https://bz.apache.org/bugzilla/attachment.cgi?id=33138&action=diff#src/ooxml/java/org/apache/poi/x
n't
answer those questions.
[1] https://poi.apache.org/spreadsheet/quick-guide.html#Validation
[2]
https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataValidation.html
On 6 Oct 2015 07:56, "Javen O'Neal" wrote:
> Please check out the patch I have in the queue for b
ns()
[3]
https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFDataValidationHelper.html
[4]
https://bz.apache.org/bugzilla/attachment.cgi?id=33138&action=diff#src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java_sec4
Javen O'Neal
On Tue, Oct 6, 2015 at 11:47 PM, Bengt R
If you're using a HSSFWorkbook, HSSFOptimiser [1] might be helpful.
Unfortunately, a XSSFOptimiser or generic SpreadsheetOptimiser
counterpart hasn't been written yet.
[1]
https://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFOptimiser.html
Javen O'Neal
On Tue, Sep 2
Adding one more thing:
Here's the specific implementation:
http://svn.apache.org/viewvc/poi/trunk/src/ooxml/java/org/apache/poi/ss/usermodel/WorkbookFactory.java?revision=1704710&view=markup#l196
public static Workbook create(InputStream inp, String password)
throws IOException, InvalidFormat
If you know you're reading an Excel 2007 file, using the XSSFWorkbook
constructor means having an XSSFWorkbook object, which has some additional
features that aren't available in the Workbook interface. If you go the
WorkbookFactory.create route, you can always cast to an XSSFWorkbook.
Likewise, y
y about HSSF
>
> What are the additional features that aren't available in the Workbook
> interface
>
> On Fri, Oct 30, 2015 at 9:14 PM, Javen O'Neal
> wrote:
>
> > If you know you're reading an Excel 2007 file, using the XSSFWorkbook
> > construct
t aren't available in the Workbook
> interface
>
> On Fri, Oct 30, 2015 at 9:14 PM, Javen O'Neal
> wrote:
>
> > If you know you're reading an Excel 2007 file, using the XSSFWorkbook
> > constructor means having an XSSFWorkbook object, which has some
> addition
Keep this in mind:
>From http://poi.apache.org/spreadsheet/eval.html:
"*Using** FormulaEvaluator.evaluate**(Cell cell)*
This evaluates a given cell, and returns the new value, without affecting
the cell"
On 5 Nov 2015 3:41 p.m., "Jason Tomforde" wrote:
> If you are referring to this ...
> CellVa
(Using POI 3.13 final)
Here's your problem:
XSSFCell cell1 = row.createCell(0); //A1
XSSFCell cell2 = row.createCell(1); //B1
XSSFCell cell3 = row.createCell(2); //C1
XSSFCell cell4 = row.createCell(3); //D1
cell4.setCellFormula("IF(A1=1, A2, A3");
A2 and A3 are 0!
Also, just a note, you do
t;A1+0=1" or "A1*1=0".
See bug 58591 [1] for example code and more information.
[1] https://bz.apache.org/bugzilla/show_bug.cgi?id=58591
On Thu, Nov 5, 2015 at 8:20 PM, Javen O'Neal wrote:
> (Using POI 3.13 final)
>
> Here's your problem:
>
> XSSFCell cell1 =
In one POI project I'm working on, I am writing a date to a cell.
I'm using
CellStyle datetStyle = workbook.createCellStyle();
dateStyle.setDataFormat(22);
Is there a POI constant that I can use instead of the number 22?
Thanks
Javen
On 13 Nov 2015 2:49 a.m., "Nick Burch" wrote:
> On Thu, 12 Nov 2015, Javen O'Neal wrote:
>
>> In one POI project I'm working on, I am writing a date to a cell.
>> I'm using
>> CellStyle datetStyle = workbook.createCellStyle();
>> dateStyl
On Nov 24, 2015 5:57 AM, "Tom Chiverton" wrote:
> So, TREND() isn't implemented. Why don't I get a NotImplementedException
> then ?
If it's silently failing rather than raising an exception
(UnsupportedOperationException("Not Implemented")), then this is something
else that should be fixed, regard
Nick Burch said:
> See
> http://people.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx
> for information on how evaluation works, functions, ptgs etc, if it's new to
> you
This presentation would have been helpful when I was first learning
how POI parses formulas. I c
people.apache.org is being decommissioned in March 2016, so if we do
link to the ppt, the file will need to be moved and the link
updated--more incentive for distributing the information across the
POI website.
On Wed, Nov 25, 2015 at 3:55 AM, Nick Burch wrote:
> On Wed, 25 Nov 2015, Ja
It might be possible for the workbook to store formula evaluation state so
you can switch between EVALUATE_BLANK_CELLS_AS_ZERO (Excel behavior) and
EVALUATE_BLANK_CELLS_AS_NULL. Alternatively, internal state might be
avoidable if the call to evaluate the cell specifies the desired behavior,
though
Adolfo,
> a powerpoint file created by the last Powerpoint version can be opened by any
> other previous Powerpoint version (e.g. Powerpoint 2007 can open pptx files
> from Powerpoint 2015)
Yes, unless the workbook contains features that were added after
Powerpoint 2007. If so, Powerpoint usual
Could you please include the Excel file that is causing this problem
and a SSCCE (short, self-contained correct example)? Without this
information, we are unable to reproduce this problem. A link to a
discussion of this problem on a Docjure forum or mailing list or an
open bug may be helpful.
It's
ss is corrupted
or you try to parse an XLS files as XLSX
* Same ZipException, cause was a 0-byte file:
http://www.lingala.net/zip4j/forum/index.php?topic=268.0
On Sat, Dec 19, 2015 at 11:45 PM, Javen O'Neal wrote:
> Could you please include the Excel file that is causing this problem
> an
Mark,
Is this a request to modify the website documentation, comments or
java docs in the source code, or Java code/functionality, or unit test
behavior, or a combination thereof? I'm a bit unclear what needs done
here. Could you open a bug and if you have a suggestion for how to fix
the bug, atta
Mark,
Were you able to get some answers about how to get a gradient fill in POI XSSF?
On Thu, Oct 29, 2015 at 12:58 PM, Murphy, Mark
wrote:
> Has anyone been able to do a gradient fill, and would be willing to show me
> the magic code? I can see methods for pattern fill, but not gradient fill.
Find-replace all ">" with ">\n", then run the diff. Alternatively, use a
text editor with HTML/XML pretty printing.
On Jan 14, 2016 19:40, "Ken Hausam" wrote:
> Thanks Nick. I'm a novice here. Didn't even know that .xlsx were zips of
> XML files.
>
> After changing chart type, only one file chang
full diff http://pastebin.com/diff/ykkGMANE
Formatted using http://www.xmlformatter.net/
On Thu, Jan 14, 2016 at 7:50 PM, Javen O'Neal wrote:
> Find-replace all ">" with ">\n", then run the diff. Alternatively, use a
> text editor with HTML/XML pretty printing.
:30 PM, Javen O'Neal wrote:
> Apparently changing chart types is a lot more complicated than
> replacing with and val="standard"/> with .
> Excel might be adding, removing, and modifying more tags than
> absolutely necessary when changing the chart types (for exam
wlines > > > > > /> > >
> >
> > P.S. the above is valid XML but NOT Valid XHTML :-)
> >
> > All the best,
> > DaveLaw
> >
> >
> > On 15/01/2016 04:50, Javen O'Neal wrote:
> >
> >> Find-repl
Make sure you call cell.setCellStyle(myCellStyle) when you're doing. You
may want to use CellUtil.setStyleProperties to avoid creating duplicate
styles or modifying the styles of other cells that share the same style.
On Jan 19, 2016 08:06, "Schene, Chris" wrote:
> Hi,
>
> I am using this code to
See
https://poi.apache.org/apidocs/org/apache/poi/ss/util/CellUtil.html#setCellStyleProperty(org.apache.poi.ss.usermodel.Cell,%20org.apache.poi.ss.usermodel.Workbook,%20java.lang.String,%20java.lang.Object)
On Jan 19, 2016 8:19 AM, "Javen O'Neal" wrote:
> Make sure you call
See CellUtil
https://poi.apache.org/apidocs/org/apache/poi/ss/util/CellUtil.html
On Jan 22, 2016 1:25 AM, "Melody" <475573...@qq.com> wrote:
> Hi !
> Thank you very much for creating such a wonderful project of Apache POI
> which
> helps a lot. And I really appreciate it.
> However, I have encount
If the difficulty here is *generating* a suitable preview image for any
embedded object (which would require POI having codecs for virtually every
media type), then couldn't we add a function to allow the user to provide
the preview image?
Slide.embedContent(document, previewImage)?
We could pack
http://stackoverflow.com/q/35506581/2683399
On Mar 14, 2016 5:21 AM, "pratibha" wrote:
> Can you please tell me step by step that how to open word document in
> android
> studio using Apache poi lib.
>
>
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/How-to-open-
view the word document. I would be
> grateful if you would tell me the steps to do the needful.
> Thanking you,
> Pratibha Mache
>
> On 14/03/16 10:17 pm, "Javen O'Neal" wrote:
>
> >http://stackoverflow.com/q/35506581/2683399
> >On Mar 14, 2016 5
That's a bug and an easy fix. Could you open a bug on bz.apache.org/bugzilla
?
On Mar 23, 2016 08:37, "Bazil" wrote:
> Hi
> I'm trying to find comments to cells on a spreadsheet.
> All is well, when comments have org.apache.poi.ss.usermodel.Sheet.
> getCellComments() returns. But when no comments
Fixed in bug 59222
https://bz.apache.org/bugzilla/show_bug.cgi?id=59222
Thanks for letting us know about this one, Vasily!
On Wed, Mar 23, 2016 at 8:55 AM, Javen O'Neal wrote:
> That's a bug and an easy fix. Could you open a bug on
> bz.apache.org/bugzilla?
>
> On Mar
As Adrián mentioned, 255 characters is an Excel format limitation that POI
adheres to.
Did you get this exception from calling setCellWidth or autoSizeColumn? The
former should raise an exception, but the latter should probably quietly
clip the auto-sized column width to 255 characters if best fit
Another example that close's save behavior is surprising to users. At
a minimum, this should not modify the file on disk, since nothing
changes (besides last accessed date),
Workbook wb = WorkbookFactory.create(aFile, null, false);
wb.close();
// for unit test, assertCloseDoesNotModifyFile(wb, aFi
Memory consumption and performance are a balancing act. POI adds data
structures on top of the XML beans that makes lookups faster, but at
the cost of duplicating the memory across multiple data structures.
Until we can read in an OOXML file, write data structures that can
fully capture the XML con
Best fit column height = ceil(best fit column width / current column width)
* (height of a character + line spacing between each line of text) + margin
top + margin bottom
This assumes all characters in the cell are the same font.
On Apr 18, 2016 9:20 AM, "Roberto Marchioni"
wrote:
> Hi everyone
rano (BS) - Italy
> ph.: +39 030 9700269
> r.marchi...@tattile.com - www.tattile.com
>
> -Messaggio originale-
> Da: Javen O'Neal [mailto:javenon...@gmail.com]
> Inviato: lunedì 18 aprile 2016 19.23
> A: POI Users List
> Oggetto: Re: Setting automatic height
Interesting. Xls extension identified as application/xml. POI does not
support the Workbook XML format. OOXML is different.
On Apr 21, 2016 8:37 AM, "Andrew Munn" wrote:
> I am using poi 3.15
>
> I can not get POI to parse these XLS files being generated by Bloomberg
> into something useful. I c
What version of POI are you using?
On May 2, 2016 03:25, "Anders Åberg" wrote:
> Hi guys
> I am trying to set RGB background colors on cells and in addition set
> borders on regions using RegionUtil. When doing this, all the cells with
> borders end up completely black.
>
> It seems that using XS
trn.unsetFgColor();
} else {
if(ptrn == null) ptrn = ct.addNewPatternFill();
ptrn.setFgColor(color.getCTColor());
}
addFill(ct);
}
On Mon, May 2, 2016 at 8:15 AM, Anders Åberg wrote:
> I'm using 3.14.
>
> -Anders
>
> On 2 Ma
atternFill();
> ptrn.setFgColor(color.getCTColor());
> }
>
> addFill(ct);
> }
>
> On Mon, May 2, 2016 at 8:15 AM, Anders Åberg wrote:
>> I'm using 3.14.
>>
>> -Anders
>>
>> On 2 May 2016 at 16:35, Javen
Could you please include a simple, self-contained correct example (unit
test) to show us what you're doing?
On May 8, 2016 11:55 PM, "Rajesh Bhat" wrote:
> Hi,
>
> Am trying to convert FO with FO: table along with style attributes to
> excel. Am trying to export into multiple sheets. This works f
Rajesh Bhat
>
> On Mon, May 9, 2016 at 12:30 PM, Javen O'Neal
> wrote:
>
>> Could you please include a simple, self-contained correct example (unit
>> test) to show us what you're doing?
>> On May 8, 2016 11:55 PM, "Rajesh Bhat" wrote:
>>
>>
Yes, if you're willing to write using CT* classes.
http://www.atetric.com/atetric/javadoc/org.apache.poi/ooxml-schemas/1.1/org/openxmlformats/schemas/wordprocessingml/x2006/main/CTBody.html
I couldn't find a higher-level abstraction on top of this in POI though.
If you get something working, pleas
gt;How I understand problem is not only on hi level interface. POI has it own
classes which implement many but not all OOXML items.
>--
>Отправлено из Mail.Ru для Android вторник, 17 мая 2016г., 18:49 +03:00 от
"Javen O'Neal" < javenon...@gmail.com > :
>
>>Yes, if
m only beginning to work
> with office document in Java and now searching for good library for my
> task. It's very interesting to read what you've written.
> >Have you ever work with docx4j library?
> >--
> >Отправлено из Mail.Ru для Android вторник, 17 мая 2016г.,
XSSF or HSSF? If XSSF, have you looked inside the XML files to see if the
internal name is there?
On May 25, 2016 3:24 PM, "Blake Watson" wrote:
> Is it possible to get the "(Name)" attribute of a sheet (rather than the
> "Name" attribute)? That is, using the "Balloon Payment Loan" calculator,
>
Nick is right about RichText.
Also check out CellUtil#setCellStyleProperty, which will avoid creating
duplicate styles or unintentionally modifying other calls that share the
same style.
https://poi.apache.org/apidocs/org/apache/poi/ss/util/CellUtil.html#setCellStyleProperty(org.apache.poi.ss.user
To better understand what the XLSX format can store, both to decipher the
XML you pasted in the previous email and to learn about any
optional tags that weren't in your snippet, you can skim through the
OOXML schema.
How to get the schemas:
If you check out and build POI, the schema will located
Excel and POI don't make a distinction between double/decimal and int. Does
Excel make any guarantees that doubles won't have precision issues?
16-digit credit cards are not storable as 32-bit ints, but require 64-bit
longs.
On Jun 29, 2016 5:53 AM, "Allison, Timothy B." wrote:
All,
On https:/
Andrei said:
> But I still think it would be nice for the root exception to be
> preserved, for future cases, to avoid guessing.
> Maybe I can convince the devs to update that line to include it.
A reasonable request.
I opened bug 59776 [1] to get this fixed.
I included the cause in the OpenXML4J
Try
https://poi.apache.org/apidocs/org/apache/poi/ss/formula/FormulaParser.html
That will give you a list of parse nodes (in RPN order, I believe. That
will need to be evaluated by some FormulaEvaluator to resolve the offset.
It's marked @Internal so it may be modified or removed without notice.
If developed, this would be a really valuable feature to the community. At
my day job, we can't load xlsx files larger than 4MB because they bloat to
1GB in the Java heap, the maximum that Oracle JRE 7 can allocate.
If you search through the mailing lists 6-12 months back, you'll find a
similar qu
Any chance you'd be willing to type up a Scala example to add to
https://poi.apache.org/poi-jvm-languages.html
On Thu, Jul 14, 2016 at 5:04 PM, Branden Visser wrote:
> *facepalm*
>
> Adding the main "poi" dependency seems to fix it. This problem smelled
> much different than a dependency issue so
Blake,
Would you be willing to contribute an example of using Apache POI in
Clojure?
We already have Jython and Scala on
https://poi.apache.org/poi-jvm-languages.html
On Feb 24, 2016 3:17 PM, "Blake Watson" wrote:
Well, it'll be in Clojure, so... =)
On Wed, Feb 24, 2016 at 2:58 PM, Nick Burch
We are looking for examples of using Apache POI in languages other than
Java to include on https://poi.apache.org/poi-jvm-languages.html
Examples should be idiomatic (they way you import, the way you loop over a
sequence with an index, the way you declare variables, whitespace, etc).
We already h
Read these two bugs to make sure that isn't the problem first. I have not
verified either bug yet.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59705
https://bz.apache.org/bugzilla/show_bug.cgi?id=59368
On Aug 11, 2016 8:30 AM, "Chris Stillwell"
wrote:
> I have a sheet with 4 columns of data t
gt; that there is a target release for the fix. I tried 3.15-beta2 which looks
> like the most current build and did not see the fix in there. Any
> expectations?
>
> Thanks again,
>
> Chris
>
> On Thu, Aug 11, 2016 at 10:45 AM, Javen O'Neal
> wrote:
>
>> Read t
See https://poi.apache.org/faq.html#faq-N10025
Tldr; CTRImpl#getDrawingList is not called by the unit tests. If a unit
test was added for this class, it would be included in poi-ooxml-schemas
On Aug 11, 2016 1:03 PM, "Branden Visser" wrote:
> Hi all, there is this dependency:
>
> "org.apache.po
The cell data format is a distinct concept from the cell value. The format
only defines how the value should be printed, but doesn't change the
underlying value.
If you want to convert the cell value to a printed string, use
https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.
To see how Excel actually saved the values, unzip the xlsx file and open
sheet1.xml. You should see a couple elements, with a value and type.
On Aug 12, 2016 8:32 AM, wrote:
The cell data format is a distinct concept from the cell value. The format
only defines how the value should be printed, b
I think I wrote that frail unit test, which looks to be (Java) platform
dependent. I'll update the test.
There is another test that tests the timing of autosizing columns, and that
test fails on slower machines or on machines where the CPU is being heavily
used by other processes while the unit te
Fixed in r1756402 [1]. Let us know if you have any other problems
building or testing.
[1] https://svn.apache.org/viewvc?view=revision&revision=1756402
On Mon, Aug 15, 2016 at 8:32 AM, Javen O'Neal wrote:
> I think I wrote that frail unit test, which looks to be (Java) platform
n, Aug 15, 2016 at 10:18 AM, Javen O'Neal wrote:
> Fixed in r1756402 [1]. Let us know if you have any other problems
> building or testing.
>
> [1] https://svn.apache.org/viewvc?view=revision&revision=1756402
>
> On Mon, Aug 15, 2016 at 8:32 AM, Javen O'Neal wrote
hine is just
a simple 17in set at 1280x1024, assuming that won't make a difference
during a remote session.
Thanks again,
Matt
On Mon, Aug 15, 2016 at 1:30 PM, Javen O'Neal wrote:
> Matt,
> Out of curiosity, are you using a very low or very high DPI or
> diagonal siz
rinted String is what I want. Am I correct?
>
> > -元のメッセージ-
> > 差出人: Javen O'Neal [mailto:javenon...@gmail.com]
> > 送信日時: 2016年8月12日 23:35
> > 宛先: POI Users List
> > 件名: Re: The CellType of a cell which is set to String
> >
> > To see how Ex
et the value 'FALSE', not lowercase 'false'.
>
> Could I achieve this by using DataFormatter?
>
> On 2016-08-19 10:48 (+0800), "Javen O'Neal" wrote:
>> Yes. DataFormatter does what you want: get the string representation of the
>>
I had some time and wrote the unit test and patch.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60025
On Fri, Aug 19, 2016 at 8:31 AM, Javen O'Neal wrote:
> https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/DataFormatter.java?revision=1753122&view
>From https://poi.apache.org/faq.html#faq-N10025
"the poi-ooxml-schemas jar only contains the XSDs and classes that are
typically used, as identified by the unit tests"
If you want to use the smaller poi-ooxml-schemas file in the future, write
a unit test that uses the missing class. We build poi-
Without more detail, my guess would be that your JVM has 2GB of XML nodes.
Nothing is flushed to disk with XSSF until you call Workbook.write, and
nothing is cleared until Workbook.close.
If you only need to create a workbook, the SXSSF streaming API is the way
to go.
On Sep 4, 2016 7:45 PM, "Hon
(i);
> for (int j = 0; j < list.size(); j++) {
> valueRow.createCell(j).setCellValue(list.get(j));
> }
> }
> wb.write(os);
> os.flush();
> }
>
> On 9/5/16, 11:25 AM, "Javen O'Neal" wrote:
teral as the cell value. As such, RichText strings
are not supported in SXSSF.
On Sep 4, 2016 22:01, "Javen O'Neal" wrote:
> Did you try os.close() and wb.close() after your flush?
>
> On Sep 4, 2016 20:50, "Hongdi Ren" wrote:
>
>> Hi Javen,
>>
&g
> Can you describe how the file is produced? Or any way of producing a
sample-file that does not contain sensitive information?
Was this file created in Outlook for Windows or Mac? Which version? If not,
some other software? Does Outlook report that the data file is corrupted?
On Sep 6, 2016 9:51
You can get the list of currently supported functions by running some code.
See Supported Functions section of
https://poi.apache.org/spreadsheet/formula.html
We use bugzilla, and spreadsheet formulas belong to the Common SS module.
https://bz.apache.org/bugzilla/describecomponents.cgi?product=POI
It is best to address these questions to the list rather than any one
individual, since that individual may be busy, less familiar with the
subject than others, or don't want to feel burdened by volunteered support.
To answer your questions, everything is possible within POI for XWPF,
though you m
l432
I don't see anything in setText that prohibits new line characters. If this
doesn't work, try creating multiple paragraphs in the table cell.
You may need to add multiple paragraphs. How does Word handle table cells
with newlines?
On Sep 19, 2016 3:42 AM, "Javen O'Neal"
No. You will need to edit the POi source and build and deploy your modified
version with your application, or just guard all calls in your application
to createRow.
On Sep 20, 2016 4:56 AM, "madhavan421" wrote:
Hi,
I want to restrict the user from creating a max of 10k rows in spreadsheet.
Do w
Sounds like a bug in the formula parser to me. Could you open a bug with a
unit test and relevant example workbook to reproduce this issue? If you
have time to look through the code to see why this is breaking it would
expedite a resolution. Otherwise, someone else may have time to find out
why hyp
Thanks for reporting this change in behavior.
I have opened bug 60253 to address this.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60253
On Wed, Oct 12, 2016 at 2:13 PM, Blake Watson wrote:
> Between 3.14 and 3.15 the return from .prettyPrint, when passed a
> ValidationConstraint with a list
Any of the following will work:
1) Use 3.15 and ignore the deprecation
2) Download 3.15 source, remove the deprecation warnings on
getCellTypeEnum, compile, and use that fork
3) Use a trunk build
https://builds.apache.org/job/POI/lastSuccessfulBuild/artifact/
4) Wait for 3.16 beta 1 release or 3.16
The Commons collection project has namespaced their library so that
collections3 and collections4 can run side by side.[1]
I don't think POI required any version of org.apache.commons.collections
prior to 3.15, if that helps.
Jasper reports will probably upgrade to collections4 in the future and
Do you have mixed POI libraries in your class path?
https://poi.apache.org/faq.html#faq-N10006
On Oct 30, 2016 20:59, "Bhaarat Sharma" wrote:
> I have an extremely simple DOC (attached). I can't seem to create an
> instance of the HWPFDocument.
>
> I am just doing
>
> HWPFDocument doctest = new
Is this a question about how to iterate over a multimap or how to set a
cell value in POI?
Read the javadocs for the multimap implementation you are using.
For example, org.apache.commons.collections4.MultiValuedMap is here:
https://commons.apache.org/proper/commons-collections/apidocs/org/apache/
We are still testing the candidate beta release. If we don't discover any
regressions, we will push the candidate artifacts to maven central. If we
discover an issue, we will need to fix the issue and generate a new release
candidate. This is why we don't push to Maven Central just yet--we don't
wa
using 3.15 and it does
> not handle CryptoAPI encryption for xls files.
> >
> > This scenario appears to be addressed by 3.16-beta2 - although i have
> only tested on one file so far.
> >
> > I will try again with 3.16-beta1-RC1
> >
> > thanks
> >
&g
Have you tried using POI 3.15?
Can you share a simplified code snippet to show what you're doing?
On Nov 17, 2016 08:22, "massimo malvestio"
wrote:
> Hi everybody! I'm facing an issue I can't solve using XWPFDocument to
> manipulate a 2010 docx.
>
> Document structure
>
>
>
>
>
> I need to
It is not possible to save the same document to both XLS and XLSX with POI.
On Nov 17, 2016 08:18, "Markus Maria Michaels" wrote:
> Is Apache POI a framework ?
>
> Is it possible to export to XLS and XLSX at the same time ?
> Do you know (other) java excel export frameworks ?
>
> Thanks.
>
> ---
This looks similar to https://bz.apache.org/bugzilla/show_bug.cgi?id=54349
The only thing missing for this bug is some unit tests. Would you be
willing to write up some unit tests and upload to this bug?
On Nov 22, 2016 4:15 PM, "Blake Watson" wrote:
> I believe I've found a bug in the RATE imp
/14087532#14087532
On Nov 23, 2016 9:34 AM, "Blake Watson" wrote:
I'd be willing to. I don't really have an idea how to start. (I'm coding in
Clojure.) Is there an orientation document for contributing to POI?
On Tue, Nov 22, 2016 at 5:10 PM, Javen O'Neal wrote:
My email editor deleted a couple links
1. Svn checkout
https://poi.apache.org/subversion.html
2. How to build
https://poi.apache.org/howtobuild.html
On Nov 23, 2016 10:13 AM, "Javen O'Neal" wrote:
> 1. Check out the code from Subversion
>
> 2. Set up your environment
Thank you to all our contributors for making this release possible.
On behalf of the Apache POI PMC,
Javen O'Neal
signature.asc
Description: OpenPGP digital signature
Thanks for the submission. I have opened bug 60416 [1] to work on this
and committed your patch.
Discussion can take place either on the bug or on the
d...@poi.apache.org mailing list. I have bcc'd user@poi.apache.org out
of the email responses.
[1] https://bz.apache.org/bugzilla/show_bug.cgi?id=
CPU pegged due the the Java garbage collector trying to clean up unused
memory. The out of memory error is raised when the garbage collector cannot
free the necessary memory for new objects to be allocated.
Have you read the FAQ yet? https://poi.apache.org/faq.html#faq-N10165
On Dec 2, 2016 00:11
tabase so that might not help me.
>
> The excess usage is only temporary, though, right? My small (<100K)
> spreadsheets seem to take about 50MB, and my large ones (5MB) seem to take
> about 500MB.
>
> On Fri, Dec 2, 2016 at 7:54 AM, Gordon Pettey
> wrote:
>
> > On Fr
In Excel with the locale set to English, entering the formula PRIX.TITRE
gives a NAME error. Additionally, opening the sample XLS workbook in
English Excel results in a NAME error when reevaluating the PRIX.TITRE
formula.
Therefore, this name is not reserved (in an English locale workbook) and
cou
1 - 100 of 167 matches
Mail list logo