Hi Ben.
POI works on binary level for Excel 97 (working for up to 2000).
So you could test 2 things:
1. Can you open your files from the Mac with such a Windows Excel? What
do you see when you choose "Save as"?
2. Can you save your files on the Mac with Excel97 format. If yes it's
quite likely th
Hi Nikos.
A) You use a template containing macros (i.e. opening it) and you write
to your desired file. Your template is unchanged on disk and you've
generated a new file containing macros.
B) For comparison you've to normalize the contents somehow. Numbers e.g.
are the same with or without leadin
Hi Ravi.
This way you save the data as strings and don't loose the format.
Starting with ' would be sufficient (without using =).
You also could save the number and format the cell properly (as you do
it if you use Excel directly). You just have to know the exact format.
Numbers then still are of
;d just increase your heap size with -Xmx
>
> -Andy
>
> Dhruti Ramani wrote:
> > I will try that but don't understand what difference its gonna make?
> > File will be still more than 2Mb.
> >
> > Denna
> >
> > Karl-Heinz Zengerle wrote:
>
Hi Denna.
Is it easy to rebuild the template from the scratch and then retry it?
Regards, Karl-Heinz.
Am Mo 28.11.2005 19:10 schrieb Dhruti Ramani <[EMAIL PROTECTED]>:
> Sorry but that could not solve the problem.
>
> Any other suggestions?
> Thanks,
> Denna
>
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
> at
>
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
>
Hi Denna.
With just 256 MB we never had problems with files of 2 MB. So I rather
assume other problems.
What's the POI version? How does the exception look like?
Regards, Karl-Heinz.
Am Mo 28.11.2005 16:47 schrieb Dhruti Ramani <[EMAIL PROTECTED]>:
> Hi,
>
> Sorry I am posting same que
Hi Vas.
Having the row you've to decide whether it's null or not. Being non null
you can retrieve a specific column. There you also have to decide
whether it's null or not null. Being non null you read the value
according to it's given type. Having a formula cell you've to know the
expected type b
Hi Pranita.
I think the evaluator was first mentioned in version 2.5.1 in these
threads. So your version might be a little bit too old. In former times
POI didn't evaluate formulas (e.g. 2.0).
Regards, Karl-Heinz.
Am Di 22.11.2005 12:45 schrieb Pranita Ambudkar <[EMAIL PROTECTED]>:
> Hello,
>
Hi Andreas.
What happens if you use a template instead of newly creating a file?
Regards, Karl-Heinz.
Am Fr 18.11.2005 02:56 schrieb [EMAIL PROTECTED]:
> When I close a spreadsheet created with POI, I get a dialog box:
>
> "Do you want to save the changes you made to ?
> Microsoft Excel recal
Hi Christian.
Be careful.
If you've a lot of date cells and do workbook.createDataFormat() for any
such cell it'll result in too many data formats. Do it just once and
then refer to it when using a date format.
Regards, Karl-Heinz.
Am Di 15.11.2005 18:32 schrieb Christian Gosch <[EMAIL PROTECT
Hi CP.
Did you use a template? If yes then try to rebuild it from the scratch.
If no then try how the reaction is when using a template.
Regards, Karl-Heinz.
Am Di 15.11.2005 00:04 schrieb CP Agrawal <[EMAIL PROTECTED]>:
> Hi,
> I get this error when I try to open an xls file generated using P
Hi Tobias.
Does this also occur if you build an Excel file with the same content
newly from the scratch? Your file seems to be corrupted.
If you increase Java VM (e.g. -Xmx256m) what's the result then?
Regards, Karl-Heinz.
Am Do 03.11.2005 20:08 schrieb Tobias Meyer <[EMAIL PROTECTED]>:
> Hel
Hi.
I think you won't find a solution. You could use an Excel file which you
will open, then modify and then save using another name. But in the case
where you must add a column with a well formatted header and formatted
data you'll have to do it via your Java program.
Regards, Karl-Heinz.
Am D
Hi Aurelie.
Some dynamic things you can "avoid" by assigning names to ranges.
Regards, Karl-Heinz.
Am Do 03.11.2005 16:12 schrieb Aurélie <[EMAIL PROTECTED]>:
> Hello
>
> I have a problem which begins giving me a head-hache.
> I've been looking on the net for 6 hours yet
> and haven't found
Hi Philippe.
According to my knowledge POI just supports Excel, Word and Powerpoint.
According to the usage of property tags it might be similar. But there
would be a big difference between Outlook and Outlook Express and in
general there wouldn't be just one file and there even could be
differen
Bonjour Christophe.
I think still just Excel97 up to Excel2000 are supported because of
different binary formats.
So you've to take care that your template is a template saved in
Excel2000 format. Excel can save files in elder formats.
Does the error still occur if you take care for that things?
Hi Regis.
Make a countertest using POI 2.0.
Regards, Karl-Heinz.
Am Do 03.02.2005 12:34 schrieb CABARET Regis <[EMAIL PROTECTED]>:
> Hi,
>
> I am using POI to convert an Excel file containing multiple worksheets
> into an ASCII file that is
> to be loaded into a database.
> The Excel file ha
Hi world.
Solved. I just had to omit =.
Regards, Karl-Heinz.
Am Di 06.07.2004 17:34 schrieb Karl-Heinz Zengerle
<[EMAIL PROTECTED]>:
> Hi world.
>
> The same happens when I create 2 string cells and append them using &.
>
> Regards, Karl-Heinz.
>
>
> A
Hi world.
The same happens when I create 2 string cells and append them using &.
Regards, Karl-Heinz.
Am Di 06.07.2004 17:28 schrieb Karl-Heinz Zengerle
<[EMAIL PROTECTED]>:
> Hi world.
>
> What's wrong?
>
> I thought to use the nearly simplest formula sample
Hi world.
What's wrong?
I thought to use the nearly simplest formula sample
oC.setCellFormula("=1+2");
and I receive an exception (Integer expected).
In Excel this would be allowed. Aren't constants within the formula
handled in POI?
Regards, Karl-Heinz.
-
t; formula result, as caculated by Excel. For new formulas entered via
> POI,
> getNumericValue always returns 0.
>
> On Tue, 2004-07-06 at 15:24, Karl-Heinz Zengerle wrote:
> > Hi Avik.
> >
> > Are you also able to evaluate all mapped formula (when a user calls
answer isn't known then a statement about the lookup
> > functions (like SVERWEIS in German) would be welcome.
> >
> > Regards, Karl-Heinz.
> >
> >
> > Am Mo 28.06.2004 15:21 schrieb Karl-Heinz Zengerle
> > <[EMAIL PROTECTED]>:
> >
> > > H
ava
>
> For names that are not recognised, POI will put in the integer for an
> user defined function. If that UDF is not defined in the excel
> template,
> Excel will show #NAME on opening the file.
>
> Regards
> -
> Avik
>
>
> PS. you had said urgent, sorry fo
Hi Michael.
I never used it myself. But according to the questions for this topic it
should work. Possibly it's an error or you use an elder version.
Regards, Karl-Heinz.
Am Mo 05.07.2004 04:02 schrieb Michael Tsai <[EMAIL PROTECTED]>:
> Hi,
> I tried to open a Excel file that has a picture in
Hi,
not just at this level it's interesting where an objects lies within its
surrounding object (and also being able to determine the surrounding
object itself). The same is e.g. at cell level.
I solved it with classes showing my own view and having a reference to
the corresponding POI object.
R
2004 15:21 schrieb Karl-Heinz Zengerle
<[EMAIL PROTECTED]>:
> Hi world.
>
> How are invalid formula detected, e.g. a function NONSENSE() not
> existing in Excel? How will the application see that?
>
> As Excel documents can also be created in OpenOffice e.g. the Bessel
> func
Hi Davinder.
Indexes start at 0. So typically a none value is expressed by a negative
value. So it's nothing strange.
Regards, Karl-Heinz.
Am Do 01.07.2004 17:15 schrieb Davinder Kohli <[EMAIL PROTECTED]>:
> In a sheet containing 65536 rows, I invoked removeRow,
> after all rows were removed t
> to save lots o'memory.
>
> Having said that, it's a lil broken at the moment since it's a branch
> based on about 2.0 code, the current unit tests don't all pass. So
> having said all that, yes, vague heh.
>
> Karl-Heinz Zengerle wrote:
>
> >
Hi world.
Is it planned to extend the actual support (loading and saving; similar
to macros)? If yes: What version will contain extended support?
Regards, Karl-Heinz.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional c
> contributing oppty :).
>
> Karl-Heinz Zengerle wrote:
>
> > Hi world.
> >
> > It looks like charts are not fully supported yet (implicitly loading
> > and
> > resaving - similar to macros; changing chart parameters) but that
> > this
> > is in
Hi world.
It looks like charts are not fully supported yet (implicitly loading and
resaving - similar to macros; changing chart parameters) but that this
is in development.
Is it already planned in which version charts are supported better (or
fully)?
Regards, Karl-Heinz.
-
Hi Larry.
The corruption effect we also had. The Excel template file was made by
copying and changing in Excel. Rebuilding the Excel file from the scratch in
Excel removed the problems. Excel files seem to have some awful form of
memorizing.
POI doesn't handle macros but doesn't remove them. So i
Hi Jean.
Excel itself seems to allocate chunks of data (16 row portions or
something like that). I was asking "Phantom cells" or something like
that possibly 2 months ago and there the topic was discussed a lot.
So the revised question would be whether also with deleting a lot of
rows the allocat
Hi Livia.
E.g. when using lists POI 2.5 made problems whereas POI 2.0 was working
well.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: LXvia Santos [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 28. Mai 2004 17:56
An: [EMAIL PROTECTED]
Betreff: I'm in troubles.
Hi ever
Hi Gowri.
Look at
http://jakarta.apache.org/poi/hssf/how-to.html
Read it exactly and there's a further link which contains that sample
HSSF class.
It's an example about reading and writing.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Durai Samy, Gowri Shankar (Cognizant
cell = row.createCell(colNum);
cell.setCellValue("1.25");
style = wb.createCellStyle();
style.setDataFormat(HSSFDataFormat.getBuiltinFormat("@"));
cell.setCellStyle(style);
And I still can not format Column A with Excel.
-Steve More
-Original Mess
Hi Jean.
In the family of LOOKUP functions in Excel some work better and some not
so good.
Does the cell even not contain a formula?
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Jean, Victor [IT] [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 11. Mai 2004 23:07
An: POI Us
Hi Steve.
Try something like
HSSFCellStyle oCS = oWB.createCellStyle();
oCS.setDataFormat(HSSFDataFormat.getBuiltinFormat("@"));// text
Does it also happen then?
I didn't discover such problems up to yet.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: [EMAIL PROTEC
Hi Dong.
Excel macros aren't lost when you modify Excel files using POI (2).
I never had to use (1).
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Dong Chen [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 13. Mai 2004 02:24
An: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
cell
I see, but I don't know beforehand how many rows I'll write. Also, the
"table" I'm trying to write should be "centered" on the sheet for
readability. I don't use the upper, lower, left and rightmost rows and
columns of my sheet. I don't know if templa
lumns of my sheet. I don't know if templates would help...
- Original Message -
From: "Karl-Heinz Zengerle" <[EMAIL PROTECTED]>
To: "'POI Users List'" <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 11:49 AM
Subject: AW: Question about Cell Styles in Excell
Hi Felipe.
In Excel you can also set styles for whole rows or columns and then
override some styles of specific cells (e.g. header cells). So it should
also be possible in POI. This way the quantity of settings should be
small.
When I hear alternating styles I'ld first think about styles on highe
Hi Felipe.
If you use a template and it's is already preformatted on cell level you
needn't do anything. If cells are newly created (e.g. just formatting a
whole row in the template) cells are newly created (and a style doesn't
apply then).
Directly in POI you might be right.
Regards,Kar
Hi Dmitry.
We had such effects when we used copied and modified templates. POI was
bringing an "unknown Ptg 3D warning" and Excel made problems. Building
the templates from the scratch led to proper results.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Dmitry Beransky [mai
Hi Raghavendra.
I thought such objects might not be touched by POI but also don't get
lost. E.g. the macros are handled like this. Our files are free from
images.
We use macros processed at startup time (+ special marks) to perform
actions which might be complicated in POI.
Can't you copy the GI
Hi Dave.
HSSFDateUtil.isValidExcelDate() is also useful for your problem. Not
always you know what type you expect in a specific cell.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Durham David Contr 805 CSPTS/SCE
[mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 7. Mai 2004 20
Hi Raghavendra.
Look at
http://jakarta.apache.org/poi/hssf/how-to.html
Read it exactly and there's a further link which contains that sample
HSSF class.
It's an example about reading and writing.
What you have to do is:
Open the template.
Do the write operations.
Save it
Hi Jean.
We had problems when we were using an Excel template file which caused
an "Unknown ptg 3d" warning when loading. When opening the generated
Excel file (load template, change it and save it using another name) we
had to answer the activate macros question twice and we had several
malfuncti
Fine.
It's also very fine that you could find all things in existing threads
and you needed just the pointer to them.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: news [mailto:[EMAIL PROTECTED] Im Auftrag von henry noerdlinger
Gesendet: Dienstag, 4. Mai 2004 15:48
An: [EMA
Hi Jeff.
Just recently there was a problem with lists in 2.5 but not in 2.0.
But don't ask me whether it's a bug or not.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Tim Wilkins [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 4. Mai 2004 13:08
An: POI Users List
Betreff: U
Hi Henry.
Look at
http://jakarta.apache.org/poi/hssf/how-to.html
read it exactly and there's a further link which contains that sample
HSSF class.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 4. Mai
Hi Henry.
So you've found a lot of information with that hint.
The classes you need (if you're not interested in styles etc.) are
HSSFWorkbook, HSSFSheet, HSSFRow and HSSFCell.
Check whether a row is null and ignore it then and check whether a cell
is null and ignore it then.
For special date h
Hi Henry.
Read the thread "Phantom cells?" and I hope several things become
clearer then.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: news [mailto:[EMAIL PROTECTED] Im Auftrag von henry n
Gesendet: Freitag, 30. April 2004 18:54
An: [EMAIL PROTECTED]
Betreff: reading cells
RNING] Unknown Ptg 3d (61)
You can't get any more detailed than using the BiffViewer :)
Karl-Heinz Zengerle wrote:
> Hi world.
>
> According to the OpenOffice documentation it seems to be a Deleted 3D
> area refrerence (or something like that).
>
> The 3c warning is easie
Hi Pavan.
We make such things after generating Excel files in an Excel macro.
Even there the order of commands is important.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Pavan Guduru [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 27. April 2004 18:55
An: [EMAIL PROTECTED]
Hi Kamala.
What I've seen in our problem case what that POI and also OpenOffice
behaved better than Excel itself.
So you'ld say better that you change from Excel to XML.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Di
Hi Kamala.
We had a template which is used for generating new Excel files. There we
had that warnings. When opening the generated Excel file we had the
problems mentioned yesterday in your other question.
First he created the template by copying and changing. I was checking
the Excel files (input
Sorry Kamala.
I thought that we were already upgrading. Were using still the final
version of POI 2.0. So make a comparison test (2.0 final versus 2.5).
Regards, Karl-Heinz.
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 26.
Hi Kamala.
I just told that testing it with your program would have needed more
time than just testing it an existing application of mine.
As your file cant fit to my application I have to throw an exception in
some of my plausibilizations. Thats what I meant with application
structure.
You
Hi Kamala.
I did all the mentioned steps without exceptions when I was running it
in a normal Java application in the debugger. I think the active cell
was (0,0).
At my test I myself was throwing an exception afterwards because your
file can't fit to the structures we expect in our application. S
Hi Kamala.
I said the files contain lists, we use POI but we dont explicitly
process lists in our POI based code.
Ive processed the file in our code. It could be opened and was just
rejected by the plausibility code. So POI has no problems with the list
when opening.
What I can state in my
Hi Kamala.
I think our files use lists but we don't explicitly process them in POI.
We've no problems and we use the newest POI version.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 26. April 2004 16:55
An: [EM
ng various tools no big differences could be stated which
could be seen as the reason for the different behaviour.
Is it possible to see more detailed messages or does somebody have an
idea how to find the Excel object which causes the problem?
Regards,
Karl-Heinz Zengerle
Hi world.
Excel made the problems. We run macros at the next startup and there it
was obvious. So from POI nothing is influencable.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 21. April 2004 18:35
An
gards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 21. April 2004 18:41
An: 'POI Users List'
Betreff: AW: how to force to be a string cell
Hi world.
At an other place we store "1.2" and it's i
ed?
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 21. April 2004 18:35
An: [EMAIL PROTECTED]
Betreff: how to force to be a string cell
Hi world.
In some cases we explicitly store things as strings. At the m
well and brought other problems.
In another application we copy a string from one cell to another
(normally empty one) via
String sTmp = oCellP.getStringCellValue();
oCellPT.setCellValue(sTmp);
There with the same data ("03/04-4") we don't have such problems.
Regards,
Karl-Heinz Zengerle
st simple files (one sheet, only numbers and text, no formats
etc).. but it hasn't been successful yet.
Regards
-
Avik
On Tue, 2004-04-20 at 13:51, Karl-Heinz Zengerle wrote:
> Hi Flavio.
>
> That other topic was my question. The result was: no. An answer of
Avik
> Sengupta near
Hi Flavio.
That other topic was my question. The result was: no. An answer 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:
Hi Sri.
Using POI it's not the easy way like directly in Excel. I see the prime
(') everywhere. When copying the value it's still interpreted as 1,2 and
then displayed like date and time.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Karl-Heinz Zengerle
ing a string and still ignoring it.
>
>Regards, Karl-Heinz.
>
>
>-Ursprüngliche Nachricht-
>Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
>Gesendet: Mittwoch, 31. März 2004 12:55
>An: [EMAIL PROTECTED]
>Betreff: HSSFCell - setCellValue("1.2&qu
tring is written the resulting cell should be a
string.
MfG
Karl-Heinz Zengerle
Hi world.
Does anybody know how to
avoid the problem above?
I’ld expect
that when a string is written the resulting cell should be a string.
MfG
Karl-Heinz Zengerle
___
More than
competence in Document Management
Hi Patrick.
For rows it seems to be similar. An example running all the time had to
be corrected.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 25. März 2004 16:29
An: 'POI Users List'
B
am, but we currently dont have anything that will parse it. I dont
know how difficult that is.
Regards
-
Avik
On Tue, 2004-03-23 at 23:03, Karl-Heinz Zengerle wrote:
> Hi world.
>
> Is it possible to
>
> - get and set sheltering mechanisms of Excel (e.g. for the
> sheet;
Original Message-
> From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 25, 2004 6:40 AM
> To: 'POI Users List'
> Subject: AW: HSSFRow.cellIterator order
>
> Hi Patrick.
> I think it's not useless. It's just not an optimum efficienc
tching
AIOOBE? Seems like a pretty nasty problem
> -Original Message-----
> From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 25, 2004 6:07 AM
> To: 'POI Users List'
> Subject: AW: HSSFRow.cellIterator order
>
> Hi Patrick.
> You
()
returns something larger, which causes problems even if I access by
column number. I end up having to catch AIOOBE :(
Patrick
> -Original Message-----
> From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 25, 2004 5:48 AM
> To: 'POI Users List'
Hi Patrick.
I posted the topic "phantom cells ...?" recently. For me it looks like
that the iterator traverses in the internal order. If you don't use the
iterator
But access the column by its number within the row you surely have the
desired effect.
Look at the last mails belonging to the topic ab
> Row1 has 20 cells
> > Row2 has 30 cells
> >
> > Row2.getLastCellNum() = 30 and...
> > Row1.getLastCellNum() = 30 (don't ask why)
> >
> > -Original Message-
> > From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
> > Sent: Wed
essage when opening. Also that happens just in some cases (the
message above and in another case with 3c (60)). As we just copy values
the result should be as good as the template.
Does anybody have an idea what this could be?
Regards, Karl-Heinz Zengerle
ou cant
> depend on the index of a record in the file.. you can only go
> by the row
> and col numbers inside the record.
>
>
> On Wed, 2004-03-24 at 16:27, Karl-Heinz Zengerle wrote:
> > Hi world.
> >
> > In a row containing 12 elements getLastCellNum() retur
ry of operations could be one reason. So you cant
depend on the index of a record in the file.. you can only go by the row
and col numbers inside the record.
On Wed, 2004-03-24 at 16:27, Karl-Heinz Zengerle wrote:
> Hi world.
>
> In a row containing 12 elements getLastCellNum() return
Hi world.
In a row containing 12 elements getLastCellNum() returns 12 also Ild
expect 11 (because of being 0-based). Also there a phantom cell seems to
be counted.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Gesendet
corresponding to column C – intuitively I’ld expect
this at index 2).
How can that be interpreted?
Is the history of manipulation operations performed on that Excel file the
reason for such a strange situation?
MfG
Karl-Heinz Zengerle
Hi world.
getLastCellNum() is a better choice. getPhysicalNumberOfCells() is just
the number of defined cells and thus non-interesting for the normal user
in most situations.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED
)
Sets the protection on enabled or disabled
and lock cells with setLocked(boolean locked)
set the cell's using this style to be locked
works fine with no encryption
-Message d'origine-
De : Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Envoyé : mardi 23 mars 2004 18:34
?
Regards,
Karl-Heinz Zengerle.
llowed.
In the further lines I didn't change the contents and there still the
wrong number of cells is returned.
Is that a known bug? Is it already fixed?
Regards, Karl-Heinz Zengerle
Guide, MS press)
Regards
-
Avik
On Fri, 2004-03-19 at 19:25, Karl-Heinz Zengerle wrote:
> Thanks Avik.
>
> The cells we've already corrected because of other reasons. It was
> exactly a cell showing #REF.
>
> Is there a documentation how to interprete such things if they
ld be harmless, but if you are rewriting.. sometimes it works,
sometimes it blows :((
Regards
-
Avik
On Thu, 2004-03-18 at 23:11, Karl-Heinz Zengerle wrote:
> Hi world.
>
> After I can process files now of about 4 MB I see the following
> messages. The things still run wonderful.
Hi Patrick.
Look at
http://jakarta.apache.org/poi/hssf/how-to.html
read it exactly and there's a further link which contains that sample
HSSF class.
Regards,Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Patrick Lightbody [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 18. März 200
Hi Patrick.
I began with a sample that was not hard to find at the POI page
(http://jakarta.apache.org/poi/hssf/hacking-hssf.html) or above.
I look whether I can tell it you more exactly. I think I still have that
sample project somewhere.
Regards,Karl-Heinz.
-Ursprüngliche Nachric
indicates? Is it fully harmless or might it
also cause crashes sometimes?
Recently there was another "Unknown Ptg" question in the POI list but
that seems to be fully different.
Regards,
Karl-Heinz Zengerle
Hi Rob.
It's passing the critical point now (run/debug; tab where you can set
the parameter; vm args: -Xmx256m).
Thanks to everybody for the big help,
Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Robert Lowe [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 18. März 2004 17:33
An: POI Use
Hi Rob.
Then I'll test it a.s.a.p. and report the result.
Thanks, Karl-Heinz.
-Ursprüngliche Nachricht-
Von: Robert Lowe [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 18. März 2004 17:33
An: POI Users List
Betreff: RE: AW: AW: AW: can't open workbook
> Do we mean the same? The setti
"Run..." options.
Best regards,
Robert Lowe
http://RMLowe.com/
-----Original Message-
From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 11:58 PM
To: 'POI Users List'
Subject: AW: AW: AW: AW: can't open workbook
Hi Avik.
I've cou
M that
is running eclipse, or inside a forked (ie, external) JVM. If you use a
forked JVM, you should be able to set its startup parameters.
Regards
-
Avik
On Thu, 2004-03-18 at 20:41, Karl-Heinz Zengerle wrote:
> Hi Avik.
>
> We call Eclipse the following way:
> c:
>
rameters.
Regards
-
Avik
On Thu, 2004-03-18 at 20:41, Karl-Heinz Zengerle wrote:
> Hi Avik.
>
> We call Eclipse the following way:
> c:
> cd \eclipse
> C:\j2sdk1.4.1_05\bin\javaw.exe -cp c:\eclipse\startup.jar
> org.eclipse.core.launcher.Main -os win32
1 - 100 of 128 matches
Mail list logo