Hi All,
On July 15th, I'll be giving a live presnetation on POI primarily
focusing on HSSF and delving into Cocoon. You
can read the summary here: http://www.trijug.org/ and perhaps read the
draft of the slides that will most likely be finished
the day before the presentation here:
It is not yet supported (to the best of my knowledge). I don't even
think we yet expose the flag to the
usermodel. The changes will require:
1. changes to the utility used to grok references to row/cell numbers
2. additional work on formulae
3. minor work in the high and low level model to
Wait, you're getting out of memory exceptions in Java or Excel is saying
OutOfMemory?
If the latter, please open a bug in bugzilla, describe, save, go back to
the bug and attach an
excel file that exhibits this behavior.
If you're unable to do this, then familiarize yourself with
If I recall, for a 4mb spreadsheet, 110 mb of heap space was required
(IIRC, after 1.0x this actually increased by 20-30mb due to performance
optimizations, however the performance optimizations were tenfold).
This may be slightly smaller or larger depeding on the amount of
repetitive string
Have you tried this against a recent nightly build (or CVS edition)?
Someone made some changes to make Japanese work. I suspect the changes
would work for russian. (Don't remember whether these made the 1.7-dev
release).
If not, give it a try and let me know if it works or not. HSSF's
Now in CVS (or tonights coming build)
1. New borders, (HAIR-THICK + dotted)
2. Fixed it so blank cells are white instead of whatever stuck.
3. Removed a bunch of print statements (doesn't flicker as much)
Next, I plan to play with data formats and/or text alignment. Feel free
to jump in at
Right, but the second part of the question. Support for unicode in
sheet names for instance, we don't
currently support correctly.
-Andy
Glen Stampoultzis wrote:
The reason why we make you select 16 or 8 bit strings is because Excel
writes out strings as compressed if it detects that the
I looked at autodetection, as I see it works properly
(the part, where the String is checked for including symbols with code
255),
but the problem with Russian, that Russian encodings use codes with code
127, so this autocheck do not detect the code.
In CP1251 russian character has codes
My money is that this is a character set issue. I don't know that POI
currently even exposes the character set properties. We currently set
the default character set (which is probably ISO-8859-1). This would be
a missing feature for the moment.
You've a few options:
1. Fix it
2. Wait for
Laubach
SAIC - Web Developer
B-1B System Support Management Division
OC-ALC/LAB, Building 3001, Tinker AFB, Oklahoma
dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 10:34 PM
- Web Developer
B-1B System Support Management Division
OC-ALC/LAB, Building 3001, Tinker AFB, Oklahoma
dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 10:34 PM
To: POI Users List
, Oklahoma
dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 06, 2002 9:53 AM
To: POI Users List
Subject: RE: IllegalMonitorStateException
On Sat, 2002-07-06 at 10:05, Adam wrote:
Just
On Sat, 2002-07-06 at 17:07, Tetsuya Kitahata wrote:
Hi, All.
I am a newer of this project, living in Japan.
Wandering the Jakarta Project Web Site, I've luckily
found this project. I am using XLS file format a lot
because my clients want to.
Excellent. If you get the opportunity
On Sat, 2002-07-06 at 18:50, Tetsuya Kitahata wrote:
Hi, Andrew,
I am very glad to your prompt reply.
UTF-8 or 16 is the general standard. Due to the nature of this project,
we should assume that the user may be using non-windows environments as
well. (I hail from a Linux box)
Management Division
OC-ALC/LAB, Building 3001, Tinker AFB, Oklahoma
dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 10:34 PM
To: POI Users List
Subject: Re
On Mon, 2002-07-08 at 11:03, óÅÒÇÅÊ ëÏÚÅÌÌÏ wrote:
Hello!
While I was studying the String functions and Excel structure, Patrick has
already done the patch. :)
Thank you, Patrick, but I have something to say, it seems to me that there
is a way to make it better.
hehe... Have at it man.
Hi Scott,
Currently HSSF doesn't support custom formats. It supports the
default formats in Excel only. If the format you're using happens to be
one of said formats you can do
HSSFCellStyle.setDataFormat(HSSFDataFormat.getFormat(#,##0.00)) for
instance.
To see relevant documentation on this
Just today I have made some approvement for Unicode sheet name.
The other developers and committers haven't checked it yet. %)
Did you post it in bugzilla? I don't remmber getting it.
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL
David,
Can you do me a big favor, generate a sheet that has this error as
simple as a sheet as possible. Attach it to a bug in
bugzilla. this will allow us to test it, do hex dumps and figure out
how to add support for it.
As it stands I'd say writing formulas is much farther along than
Thanks for doing this investigation. Still if you could give us a
couple sample sheets it would help.
(of course that statement is almost always true!)
-Andy
David N Horn wrote:
Actually, folks, after some digging around I have come up with the solution
to my own problem. It turns out the
Dagnon, Chris wrote:
1. Is it possible to specify that a cell extends across other cells, or is
this a 'chart' as mentioned recently that POI doesn't yet support? Users
are used to things like labels being centered across 5 cells and others
across 4 cells wide and 2- or 3-cells tall.
Show me the code you used to instantiate the workbook and write it back
to disk.
-Andy.
Jared Walker wrote:
Hello,
I've started to use POI to provide data export. I've run into the following
problem using POI 1.5.1 final with jdk 1.4.0. Here is the code I'm running:
int j=0;
try{
as
strings and that didn't help either.
thanks,
-Jared
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:14 PM
To: POI Users List
Subject: Re: Cell content not saving
One question. You're using setValue and passing a *double
just a guess it probably has saved a recovery file or something.
Find it, delete it, then it won't try and open it on startup
Dagnon, Chris wrote:
No one has any ideas, eh? Too bad.
Thanks,
Chris
-Original Message-
From: Dagnon, Chris
Sent: Thursday, July 18, 2002 10:28
David N Horn wrote:
I have a section of code which reads in a spreadsheet in the standard HSSF
manner as described on the project web pages. The cellIterator in use
causes me problems whenever I encounter blank cells at the beginning of a
row. As the iterator searches for physical cells, these
going on.
Like I said earlier, when I did a biffview the strings were there, but
weren't linked in to any cell. I didn't try explicitly casting the values as
strings and that didn't help either.
thanks,
-Jared
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent
1. include your drive letter in the classpath.
2. Also, please use poi 1.5.1 instead of 1.5.0.
3. If you use 1.5.1 only the POI jar will be required.
4. This particular issue I'm quite certain is not an issue with POI in
particular.
-Andy
On Wed, 2002-07-24 at 03:08, Badrinath Medendravu
Please do not use 1.5.0. Acquire 1.5.1. 1.5.1 is more stable than
1.5.1 as it has the advantages of
bugfixes. And there should be no pain in upgrading. (just swap the jar out)
-Andy
Raj Kumar Kundu wrote:
Hi Avik,
Thank you so much for your valuable help.
Can I get the patch or
customized format after predefine data format block -- am I
correct?
Please give me a solution for customizing the cell format as soon as
possible.
Thank u very much.
Best Regards,
Raj
- Original Message -
From: Andrew C. Oliver [EMAIL PROTECTED]
To: POI Users List [EMAIL PROTECTED]
Sent
Did you apply the patch that Avik referenced? Its not in the head, I
said you could apply the patch avik
replied with a link to, and then build it from the head.
-Andy
Raj Kumar Kundu wrote:
Hi Andy,
As per your previous mail, I have downloaded the current copy of POI
(using CVS
be?
Thanks,
Chris
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 4:59 PM
To: POI Users List
Subject: Re: HSSF: Multi-sheet problem
just a guess it probably has saved a recovery file or something.
Find it, delete it, then it won't try
where the barf-file(s) would be?
Thanks,
Chris
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 4:59 PM
To: POI Users List
Subject: Re: HSSF: Multi-sheet problem
just a guess it probably has saved a recovery file or something.
Find
Hi Linda,
Formulas are NOT supported in POI 1.5 and you should NOT use POI 1.5.0
anyhow. You should use POI 1.5.1 (which is the latest production
version with only minor bug fixes over 1.5.0) if you needa blessed
version (but do not need formulas).
If you need Formulas support, I would
Just for the record (and I suppose we should put this in the FAQ):
The on-site documentation is always against the head. The goal of the
site is to engage people into the project as much as to encourage them
to use POI. Basically, as a developer on the project my goal is to turn
all of you
Does the same document parse when using the HSSFSerializer inside of
cocoon? This may
be a missing element. The Serializer doesn't have great error reporting.
PLISSON Sébastien (DSIT-XS/I) wrote:
Hi,
When i try to use the HSSFSerializer from java, using an XMLReader,
i get a NullPointer
refactored there (in jakarta-commons).
-Andy
PLISSON Sébastien (DSIT-XS/I) wrote:
The same document parsed with an old version of POI (containing the
serializer,
before it was integrated in cocoon).
-Message d'origine-
De : Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Envoyé : mercredi 31
PLISSON Sébastien (DSIT-XS/I) wrote:
I tried my xml and xsl with poi under cocoon and it parses perfectly.
...
Thanks,
Seb
Humm. I'm sorry in that case I'm not sure what to say. You should try
the cocoon-user list. I've never done what you're doing before. More
folks there have.
is incompatible
with the new format?
Thanx.
Martin
Andrew C. Oliver wrote:
Martin Lang wrote:
Hi,
When I run the following very simple progam and try to open the writen
.xls file with Excel XP I get
an error message saying that the file is corrupted and some formatting
information may
Do you have the source used to generate the file? Secondly what version
of HSSF?
-Andy
[EMAIL PROTECTED] wrote:
One topic has already set the problem but none has resolve it. In fact, i
create one sheet with a lot of rows (for example 2000) and 40 columns for
each. I put not big data in
have also
logged it into bugzilla (id = 10393). No one has got back to me yet but it seems
that this is not a one off result.
Thanks,
Nitin
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2002 14:51
To: POI Users List; Marc Johnson; [EMAIL
d'origine-
De : Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 1 août 2002 13:32
À : POI Users List
Objet : Re: Impossible to read the file created
Do you have the source used to generate the file? Secondly what version
of HSSF?
-Andy
[EMAIL PROTECTED] wrote:
One topic
(U:\\Test.xls));}
catch(Exception e)
{}
-Message d'origine-
De : Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 1 août 2002 13:32
À : POI Users List
Objet : Re: Impossible to read the file created
Do you have the source used to generate the file? Secondly what version
of creating ( or get his reference) for each cell, i create the row
int the first 'for'. It makes at least 10 minutes to make the file
but it works.
-Message d'origine-
De : Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 1 août 2002 14:51
À : POI Users List; Marc Johnson
Define works with POI disables ITS logging by default.
please read:
http://jakarta.apache.org/poi/faq.html#faq-1
You should NOT run POI with logging enabled.
-Andy
Richard Li wrote:
After I rebuild the POI 1.7 milestone version, and replace PPOI1.5.1
release version. Log4J and POI can
Richard Li wrote:
If logging is disabled by default, I did not turn it on. I did not
experience any reading or writing problem.
it seems for me that poi-1.5.1.jar cannot work together with log4j.jar,
the result is that log4j stopped work anymore. Potentially there could
be other
Size of files are generally bigger in HSSF for one of two reasons:
1. Unicode - (If for some reason the strings in the file are saved as
unicode they'll be twice as big
2. Number/Multi record conversion -
We currently do not support writing:
RK
MULRK
Please supply:
1. Version of Excel
2. Version of POI
3. Code sample (what you're doing)
-Andy
Troy Motte wrote:
I am encountering a great deal of frustration with
HSSFCell, which insists on preventing me from getting
the actual string contents of a cell, even when I
format the cells as text
Are you sure they *aren't* numbers? If Excel writes them as numbers,
POI will insist they
are numbers.
run java org.apache.poi.hssf.dev.BiffViewer myfile.xls output.foo
with the POI jars in your classpath.
See if the cells are represented by LABELSST or STRING, or if its
MULRK, RK,
in
with the ` in front... that seems to convince excel
the value isn't a number so I get labelsst all the way
thru.
--- Andrew C. Oliver [EMAIL PROTECTED] wrote:
Are you sure they *aren't* numbers? If Excel writes
them as numbers,
POI will insist they
are numbers.
run java org.apache.poi.hssf.dev.BiffViewer
increase your heap size (java -Xmx100m for instance would make 100m
available to java)
-Andy
[EMAIL PROTECTED] wrote:
Hello all,
I recently created a conversion utility that reads processes records from a
result set into an HSSFWorksheet object. I just ran across a scenario where
I am
Try using a BufferedInputStream and make sure there isn't an extra CRLF
on the end of the file (this happens in a lot of these).
-Andy
Richard Li wrote:
Hi All,
I run into trouble with excel upload and POIFSFileSystem.
After the parser parsed out the uploaded excel doc from POST, if I
(needed a message to subscribe my new account, sorry for the trouble)
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
I suspect some work we're doing for macros
will resolve this problem. Stay tuned.
-Andy
Jack Cooney wrote:
When I open and modify an existing
excel spreadsheet that has cell comments,
the resulting spreadsheet is corrupt
(Excel reports: unable to open file).
Comments are definitely what
http://jakarta.apache.org/poi/javadocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getBytes()
Method getBytes - get the bytes of just the HSSF portions of the XLS
file. Use this to construct a POI POIFSFileSystem yourself.
Meaning you're getting ONLY the Workbook steam in the XLS file.
The current head of POI ( and I assume the last dev release) seems to
not set the automatic recalculation flag. Pppplease log this in
bugzilla with a small example and xls file, and maybe vote for it.
(Click bug database from jakarta.apache.org/poi). Some committers scan
the list of
Can someone submit a patch to the documentation regarding this. It
would help out a lot.
Thanks,
Andy
Gordon, Ted wrote:
Paul,
Thanks for your help. Sorry I didn't catch it in the archive.
Ted
-Original Message-
From: Paul Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14,
While I don't know what the problem is, I can assure you I've run POI
under both 1.3.1 and 1.4.0.
David N Horn wrote:
I am not sure whether or not POI is actually the culprit here (I doubt it,
personally) but I have recently tried to run an app that uses POI on a
colleague's computer under
actually read the How to
help page, of course ;))
Paul
Andrew C
Reply.
MfG,
Andy
Esseling Norman wrote:
Test
Mit freundlichem Gruß / kind regards
Esseling, Norman
Werkstudent, Siemens Dortmund IS IT PS 11, Germany
--
To unsubscribe, e-mail:
Andrew C.
Oliver To: [EMAIL PROTECTED
([64.102.254.33])
by set.superlinksoftware.com (JAMES SMTP Server 2.1a1-cvs) with SMTP ID 366;
Thu, 15 Aug 2002 18:02:05 -0400
Message-ID: [EMAIL PROTECTED]
Date: Thu, 15 Aug 2002 18:05:03 -0400
From: Andrew C. Oliver [EMAIL PROTECTED]
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0
Hi John,
This is a known issue with Formula support. Currently as I understand
it (from a previous email) clicking on the cells can get the
correct values. Regardless, I've got another project I'm finishing up
this month, and if Avik or Glen haven't fixed this by then, I will.
-Andy
John
AFAI, You can't use PrintWriter to output binary data. use
getOutputStream(). Print writer will attempt to handle
encoding which should totally mangle your binary (xls) data.
-Andy
anders wrote:
I have the similar problem, but my code is in my servlet instead of a jsp
file.
I tried to
It should be fairly simple to add this. Perhaps you could contribute a
patch:
http://jakarta.apache.org/poi/getinvolved/index.html
-Andy
Owens, Ryan wrote:
Is there a way to tell which worksheet was active the last time the workbook
was saved?
For instance, if I open the XLS file in
yangll wrote:
Does poi support to write Excel file
with picture , if can , then how to ?
thanks!
not yet.
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
oh sorry didn't notice he downloaded the source build. Run build.bat.
The rest will explain itself interactively.
Glen Stampoultzis wrote:
What is it exactly you wish to do with the files?
If you run the build file (build.bat or build.sh depending on your os) that
will let you build a
Hi Max,
Hopefully, you'll understand that AAF file format is not a high
priority. The committers are stretched a
little thin at the moment with other obligations. Our primary interest
are more widespread formats like
Excel, Word and Powerpoint. I'd never heard of AAF format, but this
strange results.
Cliff
Andrew C. Oliver [EMAIL PROTECTED]
08/29/2002 12:09 PM
Please respond to POI Users List [EMAIL PROTECTED]
To:POI Users List [EMAIL PROTECTED]
cc:
Subject:Re: EBCDIC Woes
Okay so let me restate the problem and make sure I understand it:
1. You're able to write
Currently the build does not support test cases for contrib classes.
Please enhance the build to provide this feature and supply patches.
[EMAIL PROTECTED] wrote:
Hi all,
I am trying to write testcases for my submission (BUG12102) HSSF Convenience
Methods.
In the bug, I have the attached
I looked and my read of the StringUtil and UnicodeRecord classes does
indeed indicate that this is the case.
Replace all new String(x) instantiations with new String(x), UTF-8 or
UTF-16 (where appropriate -- should be very obvious).
Hope that helps,
-Andy
Andrew C. Oliver wrote:
Can you
sorry correct constructor is here:
http://java.sun.com/j2se/1.3/docs/api/java/lang/String.html#String(byte[],
java.lang.String)
-Andy
Andrew C. Oliver wrote:
I looked and my read of the StringUtil and UnicodeRecord classes does
indeed indicate that this is the case.
Replace all new
Basically I did a search for all instances of String. Everywhere we're
doing new String(bytearray) we
need to be doing new String(bytearray, encoding) and enoding should
either be UTF-8 or UTF-16 (if you
see a check for an encoding flag and alternate flow for 16-bit then it
should be UTF-16
, is that a correct assumption?
I don't really have a lot of depth with antipede etc.. but here goes...
Eric
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 12:44 PM
To: POI Users List
Cc: [EMAIL PROTECTED]
Subject: Re: Location
I could have sworn I replied to this (but I don't see my reply) here
it goes again...
test ;-)
Hi Andrew.
I work with Jeff Knechtel, and volunteered to patch the POI code that
is causing us problems on OS390 with HSSF templates. There is
signifcant red tape (and little strange
On Fri, 2002-08-30 at 12:02, [EMAIL PROTECTED] wrote:
I could have sworn I replied to this (but I don't see my reply) here
it goes again...
test ;-)
I should be a little more patient with the balky mail server at my ISP :)
You need to subscribe to the list so I don't have to keep
they are very very silly, its a very bad bad idea to base one's format on
OLE 2 CDF if one is not Microsoft. For one, OLE 2 CDF is more or less
not streamable. (Inherant structural property).
-Andy
Kind regards,
-Max
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL
[EMAIL PROTECTED] wrote:
Hi all.
If the test portion of the build fails, it is kind enough
to point out which test class had the failure. However, it
does not tell which particular test case within blew up.
Is there any way to convince the test script to be more
verbose, and reveal
I find servlet handlers work the best.
-Andy
Paradizov, Konstantin wrote:
In IE, inline content disposition doesn't work in conjunction with
filename.
I have tested IE5.5 and IE6.0, Excel 97 and Excel XP.
-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED]]
Sent:
Oh cool. Thanks avik.
Avik Sengupta wrote:
unfortunately at the moment the best you can do is run
./build.sh site and look at the junit directory under build/docs.
If someone knows how to fix this I'll be very greatful!
./build.sh -Dtestcase=org.apache.poi.hssf.usermodel.blahblah
I agree, please contribute a patch, unit test and accompanying
documentation and I'll apply it.
prefer:
getFormattedValue() to getFormattedStringValue() -- later there will
be semantic/conceptual namespace colusion that will make the inclusion
of Formatted String confusing...
I replied later in the thread. For a workaround at the moment. do
String myvalue = + c.getNumericValue();
then use java.text.NumberFormat and cousins to format it to your desire.
See: http://java.sun.com/j2se/1.3/docs/api/java/text/NumberFormat.html
Admittedly its not a 1 for one match with
PROTECTED]]On Behalf Of Andrew C. Oliver
Sent: Thursday, September 05, 2002 4:38 PM
To: [EMAIL PROTECTED]
Subject: Re: how to get custom number format
I replied later in the thread. For a workaround at the moment. do
String myvalue = + c.getNumericValue();
then use java.text.NumberFormat
, Oklahoma
dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 4:15 PM
To: POI Users List
Subject: Re: how to get custom number format (Shawn please read)
good question. I couldn't
Hey I find this suspect... The build worked for me and this was fiex a
long time ago.
Andrew C. Oliver wrote:
Weird, that wasn't a problem the other night... just delete the HPSF
testcases since you're most likely not working
on that anyhow.
-Andy
Shawn Laubach wrote:
I get
First off you should never do what you're doing. If we have an example
that shows it this way, then it should be
fixed. You need to always store the FileInputStream in a reference
variable so that you can close it. Especially if you're using a screwy
operating system like windows 2000 which
Yes this should go in the main HSSFCell class and throw some kind of
bounds runtime exception.
Glen Stampoultzis wrote:
[EMAIL PROTECTED] wrote:
Hi all,
I was writing some code and discovered that I was writing cell's out at
column index -1.. This didn't seem to bother POI, but did tank
Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 5:15 PM
To: POI Users List
Subject: Re: how to get custom number format (Shawn please read)
good question. I couldn't figure it out either. Shawn?
Elvira Gurevich wrote:
I am sorry I did not make
I'll check the logs. Its probably due to the failing unit test. Should
build tonight.
Elvira Gurevich wrote:
Guys,
I can't see any nightly builds beyond
jakarta-poi-1.8.0-dev-20020910.jar09-Sep-2002 23:10 546K
on http://jakarta.apache.org/builds/jakarta-poi/nightly/
Am I looking
(4) Finally, since I need to effectively process all columns in all
rows, I figured it wouldnt make sense to use the eventmodel API. Do
you agree ?
No I disagree. It would reduce memory consumption to under 7 MB ofr up
to a 4mb spreadsheet. If you listen for all cell records you can
.
-Andy
[EMAIL PROTECTED] wrote:
Hmm. but if producer of Excel = M$, the answer is none whatsoever...right
Andy?
-Chris
Andrew C. Oliver [EMAIL PROTECTED] on 09/20/2002 07:53:46 AM
Please respond to POI Users List [EMAIL PROTECTED]
To: POI Users List [EMAIL PROTECTED]
cc:
Subject: Re: May
Officially English is the language of Apache and users are not supposed
to post in other languages. However, I've never held this viewpoint.
If you know good enough English you should probably use it to widen the
group of people who can answer your question. If you don't, please feel
free
Ferruccio Spagna wrote:
Hmm. but if producer of Excel = M$, the answer is none
whatsoever...right
Andy?
-Chris
Yes, I made a mistake writing 'producer of Excel' without an upper case...
But the misunderstanding was useful for getting also another interesting
answer...
Thanks
:
When will the next release be available? What will it include? Will this be
2.0?
Cliff
Andrew C. Oliver [EMAIL PROTECTED]@main.gmane.org
09/19/2002 08:29 PM
Please respond to POI Users List [EMAIL PROTECTED]
Sent by:news [EMAIL PROTECTED]
To:[EMAIL PROTECTED]
cc:[EMAIL PROTECTED
! (1.8-dev)
When will the next release be available? What will it include? Will this be
2.0?
Cliff
Andrew C. Oliver [EMAIL PROTECTED]@main.gmane.org
09/19/2002 08:29 PM
Please respond to POI Users List [EMAIL PROTECTED]
Sent by:news [EMAIL PROTECTED]
To:[EMAIL PROTECTED]
cc
release
release to the last developer release which would have fewer bugs? I know
bugs are inherent w/ open-source as well as proprietary software. This is
really one of my first experience s with open source and I'm not sure what
to expect. Thanks for your input.
Cliff
Andrew C. Oliver [EMAIL
opens, increment x. When it doesn't open, I would add a hardcoded
check into the HSSFCellUtil to prevent the user from creating too many
styles.
What are your thoughts? Also, got a first cut at test cases coming soon!
Eric
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED
Hi All,
I just cut a new development release and uploaded it:
http://jakarta.apache.org/builds/jakarta-poi/dev/bin/
http://jakarta.apache.org/builds/jakarta-poi/dev/src/
I appologize for their being no release notes. We haven't done a
fabulous job on capturing them this release and Glen (our
yangll wrote:
Dose hssf support these funcion:
In Excel , there is a protect function to provide the xsl file(the sheet ,
the workbook) from modifed by others. we can use the function from
Tools--Protection--, and there will be three options (protect sheet...,
protect workbook..., protect
care to try them.
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 5:08 PM
To: POI Users List
Subject: Re: Stack trace ArrayOutOfBoundsException when using
POIBrowser
Strictly a guess... Try not putting spaces in your file name
might want to send this to the poi-dev list.
Luc Girardin wrote:
Dear all,
To go straight to the topic, an undocumented record type (1C1h) seems
to be crucial for Excel when dealing with cells that reference other
cells, in order to decide whether they should be recomputed or not.
While this
101 - 200 of 496 matches
Mail list logo