formula's with #REF! in them wouldnt work. It should be possible to put in a
validator somewhere early in the stack to throw a better looking error.
On Friday 30 Mar 2007 1:56:20 am Karr, David wrote:
Using 3.0rc2, the formula evaluator failed on a particular cell, with
the stacktrace
even if compiling in 1.5, there is a setting to use backward compatible
classfile format. We should just set in the ant buildfile for safety, so that
we create correct builds irrespective of the java version on the release
manager's machine. (this is assuming all source does compile in the
did you try ldd on poi4r.so? or put libgcj in LD_LIBRARY_PATH?
Also, the version of Swig i used was, i believe, 1.3.27. Which is not to say
other versions wont work... we need to do some more experimentation...
On Thursday 22 Mar 2007 10:08:25 pm Jeff Swensen wrote:
I'm working on getting the
Jeff
You can certainly wrap stuff on your own, but I would figure it will be a lot
of work, which is reason I started on swig. I wouldnt start on it unless you
either have a lot of time, or some significant experience writing C
extensions for ruby (neither of which is true for me)
You'l have
Well yeah, it seems Bloodhound.Exploit.59 is billed as a 'heuristic
detection for Windows Media Player vulnerabilty ... so its not a case of a
known virus signature, but some 'smart' symantec heuristic that is going
overboard. Someone should probably notify Symantec.. .
Clamav, not being so
You'll get a FormulaRecordAggregate. From here, you can get the parsed (RPN)
formula notation. However, since formula's contain references to other parts
of the file, you'll need a reference to a workbook to get a string
representation. The method is FormulaParser#toFormulaString(Workbook,
I havent come accross this before
Sounds serious (looks like a regression), so could you send accross a testcase
please?
Regards
-
Avik
On Thursday 11 January 2007 15:52, Theo Antonopoulos wrote:
Hi everyone,
I tried alpha 2 and alpha 3 releases of POI but on both of them I get
the
for this:
http://issues.apache.org/bugzilla/show_bug.cgi?id=41026
The recommended patch does not fix it.
Regards,
Theo
-Original Message-
From: Avik Sengupta [mailto:[EMAIL PROTECTED]
Sent: 11 January 2007 10:30
To: poi-user@jakarta.apache.org
Subject: Re: Error with alpha 2
http://archive.apache.org/dist/jakarta/poi/release/bin/
Quoting [EMAIL PROTECTED]:
Do anybody have poi 2.0.jar with you. If yes share it with me.
I m in an urgent requirement.
Thanks Regards,
Sunil Kumar Dhage
Senior Software Engineer
Wipro Technologies,
I'd be surprised if shitRows work. A chart, AFAIK, isnt placed as a value in a
cell. You'll somehow need to get the anchor/location information from the
chart, and update that. Not sure if POI exports that information
The other option is to place the chart in a sheet of its own
On
Nope, I can confirm that the how-to page is up and running right now.
On Tuesday 12 September 2006 20:59, [EMAIL PROTECTED] wrote:
Hi all,
I have a requirement of modifying an existing excel file, I have tried
to do that
1. I could read from one excel (abc.xls) and write into empty excel
Some stuff that excel writes in a compressed form, poi stores in
uncompressed form. The uncompressed form is perfectly acceptable to
excel for reading. Therefore, the file size very likely increases on
reading and writing a file via POI.
The only way to solve an outofmemory at this time is
the 'default behaviour' is because Excel stores the data in that way..
ie, numbers are stored as IEEE floats within the excel file.
On load, excel applies the stored cell formatting to the double before
displaying on screen. If that is your requirement, that is what you
should do.
What's that delete cell/ create cell thing ... dont understand why you need to
do it, but I dont think the formula is going to work if you delete the cells
that it refers to...
On Wednesday 09 August 2006 18:57, Blanchette, Nicole wrote:
Hi,
I'm trying to read in an existing worksheet with
Message-
From: Avik Sengupta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 09, 2006 9:41 AM
To: poi-user@jakarta.apache.org
Cc: Blanchette, Nicole
Subject: Re: stuck on formula evaluations
What's that delete cell/ create cell thing ... dont understand why you need
to
do it, but I dont
Nope, that's not possible. The usual way to do this is to use a template file,
and fill data dynamically.
Regards
-
Avik
Quoting [EMAIL PROTECTED]:
Hi,
Would anyone know if I can programmatically add a macro to a
Spreadsheet using POI API?
Some emails going back to September 2004 say
Can you try with the new 3.0 alpha. The SST code has been significantly
re-written.
Regards
-
Avik
Quoting Manish Verma [EMAIL PROTECTED]:
Guys
I am trying to read an excel file using POI. I get the following error when I
try to open this Excel file.
Eguzki,
See this:
http://jakarta.apache.org/poi/faq.html#faq-N100C3
Regards
-
Avik
Quoting [EMAIL PROTECTED]:
Hello,
While generating a spreadsheet with some sheets (about 10) and many data
inserted into it, I got the following error when the created workbook was
opened with MS Excel
POI tries to be as compatible with Excel as possible. It does not know or care
about sheets produced by other products. If its a valid xls file, POI will
process it, subject to POI's own functionality limitations.
Regards
-
Avik
Quoting ravi shankar [EMAIL PROTECTED]:
Hi ,
I am having one
as I'm sure you've guessed, nobody here knows the answer :(
If excel creates that, the best we can do is implement it in read. For
writing, i suppose we create an area ref when such a formula is created by
POI? And if excel reads that fine, I think we are ok. There are various
places where
The sid is defined in the excel file format. Check the file format
documentation (its linked from the Poi/HSSF webpage. )
On Friday 23 June 2006 21:18, Denis Pimenov wrote:
In all ptg classes there is a sid field.. If i want to create new ptg
class(PrecentPtg for example) how i can get to know
yup, hex 3d (decimal 61) is the ID for ptgAreaError3d . So what you should be
looking for is a #REF in your sheets on a cell with a sheet reference.
Since Ptg's dont contain size fields in the records, one unknown ptg can cause
subsequent ptgs to be unrecognised. Usually, however, the error is
Not programatically. Depending on your use, using a template might help.
On Friday 02 June 2006 14:25, Julien Bittard wrote:
Hello,
I want to outlining data with POI in my Excel file. It 's possible ?
Thanks.
-
To
Manjula, HWPF currently does not have an active developer. You are pretty much
on your own when it comes to HWPF unfortunately. The best place to look for
features are to look for the tests and samples included with the source.
Regards
-
Avik
Quoting Manjula G (manjg) [EMAIL PROTECTED]:
Hi
Unlike records, whose header contains the record size, a PTG's size has to be
inferred from what kind of a ptg it is. therefore, if we do not understand a
ptg, we cannot process the subsequent stream. The commented out code is
therefore completely incorrect, and will result in a scrambled
POI does not touch any classloader by itself. Unlike some other java products
we know and love . :). So that makes it safer in such circumstances.
OT, i've found WL9.0 has much less issues with the classpath...
On Tuesday 08 Nov 2005 1:10 pm, Andreas Schildbach wrote:
Avik Sengupta wrote
Not that I know of. I have used older versions of POI in WL. Do you have any
particular concerns?
On Monday 07 Nov 2005 4:16 pm, Andreas Schildbach wrote:
Hi everyone,
are there any known incompatibilies when using POI for reading Excel
files in a WebApp under BEA Weblogic?
Regards,
AFAIK, it does. It'll also work on 1.2 with a little effort. Its best
however to compile from source, since the release builds are usually
build with the higher versions.
On Tue, 2005-07-26 at 13:15 -0400, Ram, Ashwin wrote:
Hello All:
I am currently using POI's HSSF to read an Excel
On Wed, 2005-07-13 at 16:47 +0100, Nick Burch wrote:
snip
It's the sun one, so that's a command line option. But, the build is all
done with ant automatically. So, short of changing the build.xml file post
checkout everyday, I can't see how to get it to compile down
Nick
We should probably
If you are using a bean, and have HSSFworkbook as a instance variable,
weblogic might very well re-use it.
On Thu, 2005-06-30 at 15:16 +0200, Michael Jovicevic wrote:
I Use
--
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
CVS, not SVN.
http://cvs.apache.org/viewcvs/jakarta-poi/
or
cvs -d :pserver:[EMAIL PROTECTED]:/home/cvspublic co jakarta-poi
On Thu, 2005-06-30 at 14:46 +0200, Newell William wrote:
Hello,
I cannot find the POI CVS repository for subversion.
I can get to the Jakarta repository URL:
1. Reuse your styles and formats
2. Strings take more memory than numbers
3. Test ... test... test!
On Tue, 2005-06-21 at 15:17 +0200, Marx, Stefan ext. MA Fa. Lynx wrote:
Hi List,
while dealing with POI/HSSF for several weeks in a quite big pro-
ject at my customer site we encountered some
If your sheet does not have images or form elements, then the current
CVS of POI is quite stable. Even otherwise, it might work for the
documents you use. So if it passes your tests, its stable.
however, my suggestion is, to backport the fix you want into the source
of the release you use. If
CAn this be
done in HSSF?Pls help.
If its throwing an exception, then apparently not :)
Whats a remote reference formula? Is that a pipe character? What does it
do?
Can you provide the parsed result of such a formula (using biffviewer?)
On Tue, 2005-06-14 at 12:05 +0200, Nishant Chandra
On a 1.8GHz linux (2.6) with jdk1.4.2, I can insert rows at approx 1000
per second. Except for brief pauses due to garbage collection, the rate
is resonably consistent. I've tried inserting 5000 rows with 42 cols
each.
Attached is a graph showing this performance, the behaviour should be
pretty
Somebody said they were working on this, not sure of the status.
see http://issues.apache.org/bugzilla/show_bug.cgi?id=35125
Quoting [EMAIL PROTECTED]:
Thierry, see below.
Thanks
Iain Shepherd
-Original Message-
From: Avik Sengupta [mailto:[EMAIL PROTECTED]
Sent: 22 November 2004
Can you please attach the ppt file in question to a bug on our issue
tracker http://issues.apache.org/bugzilla/ ..thanks!
On Wed, 2005-06-01 at 12:04 +0200, Stefan Gritzka wrote:
Hi!
For my little Lucene application I just tried to implement the
(cc'd to poi-user, apologies if you therefore recieve it twice)
The initial powerpoint support is now in POI's CVS, in the scratchpad area.
Tests and introductory documentation included. (Glen, could you pls regenerate
the site?)
A round of applause to Nick Burch for getting us there.
Long way
I am planning to mark the setCellType method deprecated, since the
recommended way is to user the setCellValue() method directly, which
sets the cell type lazily.
Does anybody actually need to use the setCellType method directly in a
recent version of POI?
Regars
-
Avik
To start debugging, save the file to disk from struts, and then use POI
on it.. it will give you an idea of where to look.
On Fri, 2005-05-20 at 11:56 +0100, nikita rao wrote:
Hi all,
I am using HSSF in my web application to read an
excel file uploaded by the user. The application is
The documentation on the site is always for the latest CVS version. Image
handling has been added only recently into POI CVS. Its not in 2.5.1
Quoting Franck Thery [EMAIL PROTECTED]:
Hi,
I'm working with poi 2.5.1 final and need to add a image in my
sheet... It seems
to be impossible with this
Amol, patch please? :)
-Original Message-
From: Amol Deshmukh [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 6:42 PM
To: 'POI Users List'
Subject: RE: How to mandate showing the active cell when the Excel file
is first opened?
Shawn,
the problem as I tracked it using
use a startup macro?
On Fri, 2005-04-29 at 15:04 -0500, Li, Jianming non Unisys wrote:
Hi there,
We are using POI to generate a large Excel file (the work sheet contains
around 50,000 rows of data) for our client. Our client mandates that
when the file is first opened with Excel, it
Sounds like a bug, thanks for the detailed investigation, could you please
submit this to bugzilla, and and attach the offending sheet as well? this will
ensure that this issue does not drop thru the cracks.
I was wondering, however, why all sheets dont show this problemie, what
triggers the
POI is only a file format reader/writer, not a functional equivalent
for excel.
Thus, it only writes formulas in a format excel understands, and does not
calculate formula results.
HTH
-
Avik
Quoting Alessandro Santos [EMAIL PROTECTED]:
Hi folks!
I'm facing a weird problem: when I use the POI
done that. shout if it didn't work.
On Fri, 2005-04-08 at 09:26 +0200, [EMAIL PROTECTED] wrote:
Can someone remove this user from the list?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 08, 2005 9:25 AM
To: [EMAIL PROTECTED]
If you are using a template, and all you want to do is enforce
recalculation, use a startup macro to force recalc at opening.
On Wed, 2005-04-06 at 09:54 -0400, Randy Tate wrote:
Here is the exception info that was left out of yesterday's post.
java.lang.StringIndexOutOfBoundsException:
have you tried cell.setCellEncoding()...
On Wed, 2005-03-09 at 12:55 +0100, Francesco Vivoli wrote:
Hi all,
I'm able to insert a numeric value in a cell
with the U+20AC code attached through
df = format.getFormat(...);
cell.setFormat(df);
Nevertheless after digging the archive for a
Interesting... POI bundled?
Anyways, you could use some smart awk/grep magic to change all pachage
names in all files, and recompiling (you'll probably need to change
build.xml as well)...
Altenatively, if you have full control over your app, keep new POI out
of JVM classpath, and load it from
PoiFS accepts an InputStream. What lies under that Input stream is
irrelevant as far as POI is concerned.. while the most used case is a
FileInputStream, it could be anything.
What you need to ensure however, in your method, is that the file does
not acculumate extra bytes at the beginning or
1. the size of data is not predifenend and is variable
Create a chart with a named range, and modify the range via POI. Search
the archives for some discussions on this.
2. the chart has to be a part of an excel file which is generated
?? Whats the problem with that? Just have a chart,and
http://archive.apache.org/dist/jakarta/poi/release/bin/
On Wed, 2005-02-16 at 16:49 +0100, Andr Petr (EXT) wrote:
Wow,
with 2.0 it works perfectly, text is extracted. So I will use 2.0. Where can
I download final release of 2.0? On download site is only 2.5.1 final and
2.0RC1 and 2.0RC2.
I certainly think so.
Can you attach this to bugzilla (so we dont loose this), and I'll check
this in. If you stick to this, you can be pretty sure to be proposed for
comitter.
Regards
-
Avik
On Fri, 2005-02-11 at 17:28 +, Nick Burch wrote:
Hi All
Having played a bit with the basic
Must logged on to server is not a POI exception... please check you
other layers.
On Thu, 2005-02-10 at 18:28 -0500, Konstantin Elkinyuk wrote:
Hi,
I'm having problems creating workbook during the remote call.
My exception is java.io.IOException: Must be logged on to server; it
occurs when
Quick answer: to replicate what the user sees in excel, you will, of
course, have to replicate excel functionality!
Excel stores all ALL numbers internally as binary floating point
numbers. Based on the formatting, it decides how many decimals etc to
display. Note that the formatting is stored
http://issues.apache.org/bugzilla/show_bug.cgi?id=33160
On Wed, 2005-01-26 at 16:42 -0500, Danny Mui wrote:
oof that looks awful. please post the bug up for someone to look at.
Amol Deshmukh wrote:
Hi,
following code:
cell.setCellFormula(4/2);
throws exception:
FAQ: http://jakarta.apache.org/poi/faq.html#faq-N100C3
On Tue, 2005-01-25 at 04:05 -0800, ravuthakumar G wrote:
Hi,
I am getting an error Too many cell Formatting if my
excel sheet exceeds more than 1000 rows.
Is there any limit in the file size?
Thanks,
Ravuthakumar
basic questions.. sorry!
1. Do you SAVE the file in Excel before closing.
2. Are you sure you're opening the SAVED file, and not the ORIGINAL
file?
Regards
-
Avik
On Thu, 2005-01-13 at 09:48 -0500, Kashikar, Yogita (SSD Technology)
wrote:
No macros are processed when closing the excel file.
POI will not recalc an XL sheet, sorry... Its a file format
reader/writer, not a functional replacement for Excel.
On Tue, 2005-01-04 at 12:17 +0200, [EMAIL PROTECTED] wrote:
hi people
i have a very specific need and i'm wondering if this is a POI case
i'll appreciate your answer (hints)
On Tue, 2005-01-04 at 10:36 +, Ricardo Lopes wrote:
You might get more lucky in the OpenOffice mailing list, it seems to me
that it is an OS specific bug (in O.O.).
Indeed. At the very least, if you can get the OO guys to figure out
exactly why OO is crashing (eg, on which record), we can
The width of a character is not known by POI, which lacks a font metric
implementation. You can use FOP's font metric information.
On Wed, 2004-12-08 at 11:00 -0700, David Thielen wrote:
Hi;
How do I convert from 1/256th of a character width to twips or points?
Thanks - dave
is this message:
Permission to this presentation is currently restricted. This
presentation can be opened by Microsoft Office 11 Beta or a viewer. For
more information, go to http://office.microsoft.com/viewer
Avik Sengupta wrote:
you get this message when using POI to open the file?
On Tue
POI cant do this for you yet.
On Mon, 2004-12-13 at 15:44 +0200, Gabi Florin Pop wrote:
Hi all,
I have to generate a PowerPoint presentation from a JAVA application. There
will be some templates for the documents that I want to modify and I will
have to change some text and some images
you get this message when using POI to open the file?
On Tue, 2004-12-07 at 16:12 +, Ricardo Lopes wrote:
Does POI support the PowerPoint 2003 format (is it different that the
previous one)?
I get this message while trying to open some ppt files:
Permission to this presentation is
POI pretty much HAS to parse the formula, since in an xls file, they are
stored in pre-parsed form.
And yes, named range support in formula's is weak at best. Standard
workaround - use a template to populate.
Regards
-
Avik
On Mon, 2004-10-04 at 18:59, Karanth, Ranganath Krishnayya
Jana,
This is not a forum for helping with Java programming. We're more than
happy to discuss POI specific issues.
I would once again urge you to read the POI documentation and examples.
Regards
-
Avik
On Tue, 2004-08-17 at 16:31, janarthanankesavan wrote:
Hi all,
Is there any specific
Sudhakar,
This is indeed very interesting, and surely useful to many people here.
A couple of points as we think of a plan..
Do you intend for this code to be part of POI? If so, do you think you
will be around to maintain and enhace this code?
Regards
-
Avik
On Mon, 2004-08-02 at 17:03,
and fixed an issue where non-ASCII
characters (in my case German umlauts) were not displayed correctly.
All in all, this seems to be some really good work that might be able
to help a lot of people.
Avik Sengupta has already asked Sudhakar if he wants his work to become
part of POI
archive.apache.org contains old releases.
Check the mailing list archives for the complete url, or navigate from
http://archive.apache.org
On Wed, 2004-07-21 at 19:10, Thomas Fromm wrote:
Karl-Heinz,
Test it with POI 2.0. E.g. using lists 2.5 didn't work and 2.0 did.
Thanks for the
Looking at the code, I think there are some bugs in getBooleanValue in
HSSFCell. It doesn't handle formulas. Also, with getStringValue, i'm not
sure you can differentiate between actual empty result, or bad type.
Essentially this looks like a hack, primarily becoz it depends on
functionality
seems like a bug.. can u provide the stacktrace?
On Fri, 2004-07-16 at 00:38, Brian Andersen wrote:
Thank you for the reply. Actually it is a String (I just didn't type it
correctly in the email). It is really is follows:
String formula = 22-11;
cell.setCellFormula(formula);
http://archive.apache.org/dist/jakarta/poi/release/bin/
In general archive.apache.org is the canonical source of old releases.
Yeah , I'm sure it could be better documented. Patches anyone? :)
On Wed, 2004-07-14 at 14:23, Keith Hatton wrote:
Hi,
Previously I have had success reading Excel
Where do you get the string =A7()?DIREXISTS ?? If it is from one of
POI's viewers, then well, actually that is how formulas are stored in
xls files, in Reverse Polish Notation. However, if this is how you see
it in excel, its obviously wrong. I believe user defined functions in
the workbook
Have you yearned to use the wonders of POI in you .NET applications?
Well, then yearn no more. POI compiled into a .NET dll is available at
http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
The following C# code uses poi to create a new excel file.. it compiles
and runs successfully
On Thu, 2004-07-08 at 19:31, Kais Dukes wrote:
Hi Avik
Thats really cool.
Is this just HSSF, or Word as well??
Kind Regards,
Kais
-Original Message-
From: Avik Sengupta [mailto:[EMAIL PROTECTED]
Sent: 08 July 2004 14:50
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject
As I said, its cool... have you seen people running eclipse inside IKVM
inside mono? Its totally cool and totally useless ..
But if you wanted to, you could provide reasons like
1. Office COM components are not recommended to be used server side.
(Michael Veit just sent a mail with much more
, 2004-07-01 at 21:40, Christian Schuhegger wrote:
Avik Sengupta wrote:
All 2.X releases are off a REL_2_BRANCH. If you checkout cvs as of March
4, 2004, you'll get what is known as the 2.5-final release. But why
would you want to do that anyways, when you can download the pre-built
version
HEAD builds what will eventually become 3.0. You seem to have found a
bug in the build.xml for that.
All 2.X releases are off a REL_2_BRANCH. If you checkout cvs as of March
4, 2004, you'll get what is known as the 2.5-final release. But why
would you want to do that anyways, when you can
As you have guessed, POI is essentially a file reader/writer. It does
not aim to replicate the functionality of Excel. So unfortunately, it is
not meant to be used as replacement for excel.
Regards
-
Avik
On Sat, 2004-06-26 at 16:44, Pedro Vivancos wrote:
Hi friends!
I am trying to use an
Styles are always created anew, and its the application writers
responsibility to track and cache them. I would imagine font objects
behave similarly, cant be sure without checking the code.
On Tue, 2004-06-22 at 04:30, Chris Cheshire wrote:
If I create a font in a workbook, does it always
This is something called rich text in excel, and is one of the more
horrific things ... It took POI a while to even get to the stage where
it wouldn't corrupt files with rich text cells in it. I believe there
still are some issues with the combination of Rich text and 2-byte
chars. So I dont
Are you sure unsubscribe confirmation messages are not being caught up
in YOUR mail filters?? Anyways, i've asked the admins...
On Thu, 2004-06-03 at 18:33, [EMAIL PROTECTED] wrote:
I have already tried that
I am stuck on all of the following lists:
'[EMAIL PROTECTED]'
POI is a file format processor, not a JAVA front end to excel.
On Fri, 2004-05-21 at 17:36, Majumder, Sanjib (Cognizant) wrote:
Hi,
I want to know how to remove Standard and Formatting options from the
ToolBar of any Excel file. I need to implement this change by using POI API.
If you would have spent some time on the net, you would have found
http://jakarta.apache.org/poi/hssf/index.html which tells you all you
need to know to get started.
On Fri, 2004-05-21 at 17:34, Durai Samy, Gowri Shankar (Cognizant)
wrote:
hi..
i am new to POIFS..
my requirement is to
Not that I know of :(
On Fri, 2004-05-21 at 07:02, Jean, Victor [IT] wrote:
I did some additional testing and it appears that when I call
sheet.removeRow(row);, it clears out the row contents, but doesn't actually remove
the row. So, I basically have a spreadsheet with 2800 blank rows
AFAIK, the parser does not support that kind of a range assignment. When
writing the named ranges parser, it appeared that it had wide ranging
format support, but one is constantly surprised by the range (sic) of
ways in which named ranges can be specified.
On Fri, 2004-05-14 at 15:07, Tony
1) Can I use POI to write (export) VBScripts macros to an Excel spreadsheet
(.xls) file? If yes, then what version of POI (HSSF) do I need?
Nope.
2) If I aleady have a separately developed Excel spreadsheet with embeded
VBScript macros, can I use POI to write (export) additional
of Avik
Sengupta near the end of all mails was clearly stating this.
Regards, Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Flavio Palumbo [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 19. April 2004 23:21
An: [EMAIL PROTECTED]
Betreff: out of memory in xls files
Hi all,
I'm
questions which you
might not perfectly answer.
Unfortunately some people in this world trust answers more when a
well-sounding name can be mentioned. And you're name is surely belonging
to them.
Regards, Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Avik Sengupta [mailto
Dont you have access to google
http://www.google.com/search?hl=enlr=ie=UTF-8oe=UTF-8q=RTF+parser+javabtnG=Search
On Tue, 2004-04-06 at 11:06, Koundinya (Sudhakar Chavali) wrote:
Hi all,
Can any body provide me the links to Open Source API for parsing
RTF format content to text content
Can you guys add example excel files to bugzilla, so that we can be sure
that this is fixed in a subsequent release. The more, the merrier.
On Thu, 2004-03-25 at 19:39, Giuseppe Costagliola wrote:
We use POI on a iSeries.
We updated to 2.5 but last week we had to roll back to 2.0 because if
AFAIK, you can protect a sheet. You cant protect individual cells or
ranges with POI.
Macros are are different OLE stream, it does not get into HSSF at all
(only the workbook stream does). POIFS will give you a handle to the raw
stream, but we currently dont have anything that will parse it. I
I suppose it depends on whether you are keeping references to the inner
class. If you are keeping references, you can write an accessor for the
style object. If you are not keeping references, put it in a Map,
possibly with col numbers as keys.
Hope that is not totally tangential to what you were
Lord Tennyson wrote this 1854, but it applies to working with Excel as
well ;)
Theirs not to make reply,
Theirs not to reason why,
..
But seriously, there are entries for many empty cells in an Excel file.
Dont ask why, but history of operations could be one reason. So you cant
depend on the
HWPF is still an experimental component. It is best if you get the code
directly from CVS. Its available in the scratchpad module of the POI CVS
repository.
On Wed, 2004-03-24 at 16:31, Anju Murthy wrote:
Hi,
I am looking for the jar file to start using HWPF. I have to read a word
document
3C is a ptgRefErr3d ie, Erroneous 3D Reference .. essentially, cells
that show as #REF in Excel.
The best is to remove these from your sheet. If you are reading, it
should be harmless, but if you are rewriting.. sometimes it works,
sometimes it blows :((
Regards
-
Avik
On Thu, 2004-03-18 at
corrected because of other reasons. It was
exactly a cell showing #REF.
Is there a documentation how to interprete such things if they occur
again later?
Regards, Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Avik Sengupta [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 19
I am confused myself about what can be done and what cant, which sheet
references.. can you give an example of what exactly you are trying to
do... alternatively, if you can browse the Bugzilla lists, there are a
few enhancement requests that describe what's missing.
On Thu, 2004-03-11 at 00:58,
I dont know ..but you can look at the usermodel implementation and see
the hoops that one has to go thru... I think there is some element of
cross references here, you'll have to figure it out from the specs..
On Wed, 2004-03-17 at 21:43, McIntosh, Mike wrote:
Thanks, that's easy. But I still
What's your file size? How much JVM memory are you using? if you are
calling from JSP or Eclipse, remember that tomcat(or any other
container)/eclipse itself will use up a large part of the available
memory.
Check it out standalone first, then add the amount of heap required to
get it to run
1 - 100 of 246 matches
Mail list logo