Re: MergeCells

Skondras P. wrote: >Hi >I have a simple i think question. >If i create two cells can i merge them afterwards? >thx > > Does this help: http://jakarta.apache.org/poi/javadocs/org/apache/poi/hssf/usermodel/HSSFSheet.html#addMergedRegion(org.apache.poi.hssf.util.Region) > > >-

Re: Do charts already work?

From scratch? No. (Though theretically all the low level structures required for a bar-chart are there) However, I'd be interested to see what output 1.8 gives with your sheet and if it does corrupt it, I'd love to see a before and after so that I can figure out what went wrong (create a bug

Re: formulas in sheet don"t recalculate after cell value changes(Avik please read)

[EMAIL PROTECTED] wrote: > Hello again, > > Thanks a lot for help with charts :) > Next problem is there are some formulas on my sheet. > When I change any cell value then save new workbook the formulas exist but > don't recalculate after changes and they alter the old values. This is a known bu

Re: HSSFPrintSetup

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 i

Re: HSSFSerializer / Null Pointer exception

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

Re: HSSFSerializer / Null Pointer exception

r is being 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. Olive

Re: HSSFSerializer / Null Pointer exception

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 hav

Re: Error when reading a XLS file with Excel XP

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 got lost. > The error occurs only when the file I read in (template.xls) h

Re: IS there a number of rows/columns limited?

You can only create as many columns as excel will allow. I've created sheets with the maximum allowed in excel, but it escapes my memory what that is, but if I recall its > 100. The initial capacity is a compile-time performance optimization. ITs for array lists and hash tables/etc in certai

Re: Error when reading a XLS file with Excel XP

some undefined records. Does this mean that POI is incompatible >with the new format? > > > >Thanx. > > > Martin > >"Andrew C. Oliver" wrote: > > >>Martin Lang wrote: >> >> >>>Hi, >>> >>>When I run th

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 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 i

Re: MEGA SST Record (was: Re: Impossible to read the file created)(GLENPLEASE READ)

I 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 20

Re: Impossible to read the file created

lasseur.createSheet("Essai Gd Fichier Feuille >>01"); >>HSSFSheet moFeuille02 = moClasseur.createSheet("Essai Gd Fichier Feuille >>02"); >> >>for(int i = 0; i < 3500;i++) >>{ >> for(int j=0;j<40;j++) >> { >> HSSFRow

Re: MEGA SST Record (was: Re: Impossible to read the file created) (GLEN PLEASE READ)

e 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; [EMAIL PROTECTED] >Objet :

MEGA SST Record (was: Re: Impossible to read the file created) (GLENPLEASE READ)

>for(int i = 0; i < 3500;i++) >{ > for(int j=0;j<40;j++) > { > HSSFRow r = moFeuille01.createRow((short)i); > HSSFCell c = r.createCell((short)j); > c.setCellValue(i + " " + j); > } >} >try{ > moClasseur.write(n

Re: MEGA SST Record (was: Re: Impossible to read the file created) (GLEN PLEASE READ)

SSFRow. >Instead 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é : j

Re: MEGA SST Record (was: Re: Impossible to read the file created)(GLENPLEASEREAD)

"workbook2.xls"); > wb.write(fileOut); > fileOut.close(); > }//end main > > }//end class > > > > > > > -Original Message- > From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] > Sent: 01 August 2002 16:20 >

Re: POI and log4j

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

Re: POI and log4j

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 fa

Re: Size of the output file

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

Re: why can't I get the string value of a cell?

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 tex

Re: why can't I get the string value of a cell?

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", "R

Re: why can't I get the string value of a cell?

ers, that's up to you. -Andy >I guess my only choice is to have people put stuff 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 PR

Re: Out of memory error...

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 ge

Re: POIFSFileSystem

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

Re: POIFSFileSystem

great! I would remove them as a matter of practice BTW, even for the non-POI stuff. Richard Li wrote: > right, I noticed this. After remove the extra 2 bytes, it works ok. > > At 09:10 PM 8/9/2002 -0400, you wrote: > >> Try using a BufferedInputStream and make sure there isn't an extra >> CRL

ignore

(needed a message to subscribe my new account, sorry for the trouble) -- To unsubscribe, e-mail: For additional commands, e-mail:

Re: POI-HSSF and Cell Comments

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

Re: Sending workbook as a mail attachment

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.

Re: SUMIF() problem (AVIK)

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 unresolv

Re: SUMIF() problem (AVIK)

I'm not exactly sure where the flag is. I forget. To determine this do the following: create a sheet with the formula in Excel create the exact same sheet in HSSF do a java org.apache.poi.hssf.dev.BiffViewer excelsheet.xls > output.foo java org.apache.poi.hssf.dev.BiffViewer hssfsheet.xls > o

Re: HSSF: Setting fit to page option doesn't seem to work

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, Augu

Re: compatibility

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 W

Re: HSSF: Setting fit to page option doesn't seem to work

way? > > Other than that, I'll gladly submit the patch (after I actually read the "How to >help" page, of course ;)) > > Paul > > > > >

Re: Test, do nor reply!

Reply. MfG, Andy Esseling Norman wrote: > Test > > > > Mit freundlichem Gruß / kind regards > Esseling, Norman > Werkstudent, Siemens Dortmund I&S IT PS 11, Germany -- To unsubscribe, e-mail:

Re: HSSF: Setting fit to page option doesn't seem to work

fun thing to do in the weekends! > > why yes! POI == fun! :-) -Andy >Paul > > > > > > > "Andrew C. >

Re: [Fwd: Encoding in HSSF (XLS) Serializer]

You know... I don't think it does yet. It would make sense to set the underlying encoding to unicode (16-bit) if per chance the locale isn't set to us/uk/austrailia. (we use the locale for numbers) I'll fix this when I get a chance if someone else doesn't beat me to it. (Its a very simple

re: Request

Received: from rtp-isp-nat1.cisco.com ([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" &

Re: Out of memory error...

The only options that drastically affect HSSF's running out of memory is the -mx option. The "heap space". I don't think increasing stack space is very important (objects are stored on the heap and we don't make significant use of recursion). As for building on disk...we're planning that in a

Re: Out of memory error...

ous in HSSF for 2.0 than I imagine it will be for 3.0. (build on 2.0 graph support add image support) -Andy >Thanx again, >Cliff > > > >"Andrew C. Oliver" <[EMAIL PROTECTED]> >08/19/2002 12:43 PM > > > > > >Please respond to "POI Users

Re: Existing Excel Files

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 Ri

Re: downloading excel file

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 i

Re: Can I get the "active" worksheet?

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 Exc

Re: Does poi support to write Excel file

yangll wrote: >Does poi support to write Excel file >with picture , if can , then how to ? >thanks! > > > not yet. -- To unsubscribe, e-mail: For additional commands, e-mail:

Re: help required

Devarajan wrote: >Hello, >I have downloaded jakarta-poi-1.7.0-dev-src.zip but I am unable to move along since I >could not find any "readMe' sections. > >Can anybody tell me how to go about working the files..I am having Win 98 system > >Thanks >Devarajan > > > The jars are under "build". -

Re: help required

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 bi

Re: POI & AAF

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 probab

Drop support for 1.22? (was: Re: Which java version is recommendfor the latest nightly build)

1.2.2 is supposed to work, but I have to admit I presently only test on 1.3.1 and 1.4.0. Using 1.3.1 you're practically guaranteed compatibility as the site and nightly builds are presently generated with it. (site every 2 hours, nightlies at 2am EST) > I'm using the JDK 1.2.2 which obviously

Re: EBCDIC Woes

Okay so let me restate the problem and make sure I understand it: 1. You're able to write text on the OS390 into String cells (LabelSSTRecord/SSTRecord for those who pay close attention ;-) ) 2. You're not able to read text on the OS390 Are you able to read the workbook into an object? If

Re: EBCDIC Woes

27;ll >probably try this later today and see if I get any strange results. > >Cliff > > > >"Andrew C. Oliver" <[EMAIL PROTECTED]> >08/29/2002 12:09 PM > > > > > >Please respond to "POI Users List" <[EMAIL PROTECTED]> >

Re: EBCDIC Woes

> > >>Can you get the Sheet name? If so then its probably in SSTRecord or its >> support classes. >> >> > >No, the sheet name is scrambled. > > Then that points to StringUtil or UnicodeString (most likely) > > >>What must be happening is that when the String is deserialized from the >>SS

Re: Location for POI contrib Testcases?

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 attach

Re: EBCDIC Woes

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. Ol

Re: EBCDIC Woes

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

Re: EBCDIC Woes

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-1

RE: Location for POI contrib Testcases?

d should fail, since > contrib code is at a lesser scrutiny, 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

Re: EBCDIC Woes

Nicola Ken Barozzi wrote: > > Andrew C. Oliver wrote: > >> Great, and if you're able to produce a unit test that demonstrates >> this we'd appreciate it. I hope to eventually >> find someone with a default encoding such as EBDIC who could >> regul

Re: Location for POI contrib Testcases?

hat if >a contrib fails a testcase, that doesn't mean a build should fail, since >contrib code is at a lesser scrutiny, is that a correct assumption? > >I don't really have a lot of depth with antipede etc.. but here goes... > >Eric > >-Original Message- &

Re: EBCDIC Woes

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 stran

Re: EBCDIC Woes (Glen ye ol' branchmaster please read)

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

Re: JUnit Test Failure -- which test failed? (Nicola Ken pleaseread)

You know, if you feel like fixing that issue with the command line edition of the test script, I will be very grateful. I asked Nicola Ken and he replied but I forgot what he said. If not ./build.sh site will generate the site and then you can look at the html page (local version of: http:

RE: POI & AAF

atchpad until its mature. If you have any ties to the body coming up with this standard. Tell them 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

Re: JUnit Test Failure -- which test failed?

[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

Re: Servlet / POI question

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]] >Se

Re: Servlet / POI question

you twice whether you want to save file or open it. First time it >asks whether you want to open >it and shows you the URL of the servlet and second time it shows you the >"filename" that you specified >in Content-Disposition. > > > >-Original Message- &g

Re: Servlet / POI question

> >Just throwing out the idea...! > >Eric > >-----Original Message- >From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, September 04, 2002 5:33 PM >To: POI Users List >Subject: Re: Servlet / POI question > > >Paradizov, Konstantin wrote: > &g

Re: JUnit Test Failure -- which test failed?

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

Re: how to get custom number format

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... Peda

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 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

Re: how to get custom number format (Shawn please read)

From: news [mailto:[EMAIL 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 > >Str

Re: how to get custom number format (Shawn please read)

ion >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: Thursday, September 05, 2002 4:15 PM >To: POI Users List >Subject: Re: how

Re: Build Failure

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 the following: > >test: >Compiling 1 source file to C:\Documents and Settings\Shawn Laubach\My >Documents\ >src\poi\jakarta-poi

Re: Build Failure

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. > > -And

Re: more info on new HeaderBlockReader errors

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 whic

Re: about "A1" and "R1C1" reference styles

Iouri Michtchenko wrote: > Hi, > I have a question about formulas: > Does POI support "R1C1" reference style? If yes how one can turn it on? > > Regards, > Iouri. not yet. Its a contribution opportunity. ;-) -- To unsubscribe, e-mail: For additional commands, e

Re: Should I be able to write to column index -1?

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

Re: how to get custom number format

K >thanks, > > >-Original 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. S

Re: nightly builds missing

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 loo

Re: simple download question

The production "releases" are more or less stable. The primary things you gain from getting a nightly build or development release involve: 1. Support for international character sets (French should be okay but Japanese or Russian might not) 2. Formula support 3. Custom data formats 4. Earl

Re: nightly builds missing

It appears that James (jakarta.apache.org/james) filled up my disk for some reason... Hence the nightly build had no where to go. This has been remedied and the nightly build should run tonight. -Andy On Thu, 2002-09-12 at 10:28, Elvira Gurevich wrote: > Guys, > I can't see any nightly builds

Re: Number Problems

This is expected. http://mindprod.com/jglossfloatingpoint.html Its a tradeoff, should we use BigDecimal and bloat the memory requirements substantially (another object per numeric cell) or use double and live with 2.1 becoming 2.101 somtimes. Because generally this will round of

Re: HSSF Scalability

> > (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

Re: Help on ReaderWriter.java

do not compile it like that. do: "build.bat" and then put the resulting jar in your classpath. No offense but it looks like you really need to go through the Java tutorials (java.sun.com) on setting classpaths, etc. Using POIFS probably calls for a high level of Java aptitude due to the natu

Re: Copying cell styles

Bill Nalen wrote: >Is it possible to copy a cell style from one cell to another? I've >searched the mail archives & bug list and couldn't find anything that said >I shouldn't be able to. Here's what I'm trying to do: > >HSSFCell cellFrom = get from workbook based on sheet, row #, column # >HSSF

Re: Copying cell styles

No problem :-) - Thats one of the reasons I usually ask...happens to the best of us. -Andy Bill Nalen wrote: >No need to post a bug, I realized what I was doing wrong. I should have >tried a simple program before bothering the list. > >Thanks >Bill > > > >-- >To unsubscribe, e-mail:

Re: May I ask a question?

I'm not entirely sure I understand the question? Do you mean what is the attitude towards support amoung the developers? Always remember we're volunteers and you're not paying for the mortgage. My attitude is that I'm willing to helpif you are. Meaning if POI were on the operating tabl

Re: May I ask a question?

help us in our task. -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 > >Pl

Re: Copying cell styles

ers of regions where each edge is slightly different! > >Eric > >-----Original Message- >From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] >Sent: Thursday, September 19, 2002 5:53 PM >To: POI Users List >Subject: Re: Copying cell styles > > >Bill Nalen wrote: &

native language questions on poi-user

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 to

Re: May I ask a question?

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

Re: COME AND GET IT!! FRESH POI! (1.8-dev)

[EMAIL PROTECTED] wrote: >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

Re: COME AND GET IT!! FRESH POI! (1.8-dev)

TECTED]> > >To:"POI Users List" <[EMAIL PROTECTED]> >cc: > >Subject:Re: COME AND GET IT!! FRESH POI! (1.8-dev) > > > >When will the next release be available? What will it include? Will this be >2.0? > >Cliff > > > >"

Re: COME AND GET IT!! FRESH POI! (1.8-dev)

ggest >>using them in production code would you? >> >>Cliff >> >> >> >>[EMAIL PROTECTED] >>09/20/2002 11:29 AM >> >> >> >> >> >>Please respond to "POI Users List" <[EMAIL PROTECTED]> >> >>

Re: COME AND GET IT!! FRESH POI! (1.8-dev)

of my >questions. Thank you for your response. > >Cliff > > > >"Andrew C. Oliver" <[EMAIL PROTECTED]> >09/20/2002 12:46 PM > > > > > >Please respond to "POI Users List" <[EMAIL PROTECTED]> > >To:POI Users List <[

Re: Copying cell styles

nerates x number of styles. Then, if the >document 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!

COME AND GET IT!! FRESH POI! (1.8-dev)

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

Re: Does hssf support protection

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..., prot

Re: Stack trace ArrayOutOfBoundsException when using POIBrowser

Strictly a guess... Try not putting spaces in your file name and specifying a complete path. These are Excel 97+ right? Dennis Doubleday wrote: >Using 1.8.0-dev POI, I got the following stack trace on two of six XLS >files I tried to read: > >C:\Documents and Settings\ddoubleday\Desktop> java >o

Re: Stack trace ArrayOutOfBoundsException when using POIBrowser

Excel 2000 and Excel XP. >> >>I tried your suggestions but the errors remain. I could email >>them to you directly if you care to try them. >> >> >> >>>-Original Message- >>>From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]

Re: Record 1C1h

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 t

<    1   2   3   4   5   6   7   8   9   >