poi.hssf sadly has no support for named Areas yet. :-(
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
it worked fine for me.
A stupid question: you are looking in the right directory for the files?
(e.g. new FileInputStream(D:\\Temp\\apache.poi\\test.xls))
Regards from the Odenwald,
DaveLaw
[EMAIL PROTECTED] wrote:
That's the way I already tried it. But there is something I am doing wrong
Hello Anthony,
try this...
cell.setCellFormula(HYPERLINK(\http://www.apconsult.de/kont.htm\;,
\Contact\));
...we use it all the time.
Regards,
DaveLaw
- original message
Subject: hyperlink
Sent: Tue, 30 Oct 2007
From: Anthony VIOLO /avi .S[EMAIL PROTECTED]
Hello,
I'd want
Could it be, the HSSFCell getCell(short cellnum)
method has been rather confusingly deprecated?
Arguably, its laudable to avoid sign extension,
but as there can only be 256 columns anyway,
I find it really rather misleading.
Regards,
DaveLaw
Hi Josh,
thanks for that thorough explanation.
My formulation was rather ambiguous.
The need for migrating to int is clear.
My issue is that for Rows it makes sense in the HSSF world to
convert to unsigned short by AND'ing with 65535, as that is
the maximum no. of rows, but for columns the max
Hi,
I am using...
DataFormatter.formatCellValue(Cell cell, FormulaEvaluator evaluator)
...to format a Cell containing a Date.
My (german) Excel shows the Date as follows: 14. Jan
(with a space between the dot and the J no quotes)
cell.getCellStyle().getDataFormatString() returns d-mmm
whereas
);_($*(#,##0.00);_($*-??_);_(@_) _-*
#.##0,00 €_-;-* #.##0,00 €_-;_-* -?? €_-;_...@_-
31 00:00 45: mm:ss mm:ss
32 768:00:00 46: [h]:mm:ss [h]:mm:ss
33 00:00,0 47: mm:ss.0 mm:ss,0
34 34,0E+0 48: ##0.0E+0 ##0,0E+0
35 35 49: @ @
David Law wrote DataFormatter.formatCellValue :
Hi,
I am using
oh, I just love systems that reformat stuff...
...computers (in particular microsoft) should leave the thinking to
human beings!
Pls find formatted list in attachment. :-)
DaveLaw
David Law wrote:
Hi,
well no one responded to my original posting, so I've researched some
more.
It would
Hi,
sorry its taken so long to post this, I've been mulling over...
...and I see the patch has been applied.
As Yegor mentions in the Bug report...
mod(-3.4,2.0) being 0.60...01
...is due to binary arithmetic.
Now I just wondered how OpenOffice got it right and stumbled over
some code to round
Hi Yegor,
I think I probably didn't express myself quite clearly there...
...I should have put that right in quotes, meaning
that OpenOffice gets the /same/ result as Excel.
Its only right in the sense that its the same as Excel,
but the Excel result may well be wrong.
But, right or wrong; I
Andrey,
I don't think they have to make-believe they are clever.
Working mostly in their spare time, they have put together
an amazing piece of software which is used and appreciated
by thousands thousands of businesses individuals worldwide.
Sometimes I am quite amazed at how people bend
project of my own at present.
Best regards,
DaveLaw
- original message
Subject: Re: POI 3.7 can't get formula
Sent: Mon, 15 Nov 2010
From: Nick Burchnick.bu...@alfresco.com
On Sun, 14 Nov 2010, David Law wrote:
Here...
http://www.apconsult.de/projects/persella
It may be a longshot, but as its sporadic, make sure the file is
not still open in javaMail when you start reading it with poi.
Depending on the File-system, that can make a difference.
If possible, I try to have the sending-system rename the File
the receiving-system will first see it after
Hi,
having read FAQ 14 http://poi.apache.org/faq.html#faq-N10109, where it
states the ooxml-schemas sources
ooxml-schemas-src are available on maven, I've spent several
hours dredging the Internet (including maven) for them.
I can't find 'em anywhere, having reached the last page of the
anything at maven central.
And I don't seem to be
http://permalink.gmane.org/gmane.comp.jakarta.poi.user/19467 alone there.
All the best,
DaveLaw
On 30.01.2014 12:13, Nick Burch wrote:
On Thu, 30 Jan 2014, David Law wrote:
I can't find 'em anywhere, having reached the last page of the
Internet
Simanchal,
may I ask a couple of stupid questions?
I've removed some dead code what's left
in the heart of all those nested if's for's is this:
CTRegularTextRun[] ctRegularTextRun =
xslfParagraph.getXmlObject().getRArray();
for (int index = ctRegularTextRun.length - 1; index 0; index--)
On 30.01.2014 21:45, Dominik Stadler wrote:
Hi, seems your best bet is to run the build locally, you can get the
jar built via Ant-target compile-ooxml-xsds, the resulting jar is
ooxml-lib/ooxml-schemas-src-1.1.jar
Dominik
On Thu, Jan 30, 2014 at 12:29 PM, David Law david@apconsult.de wrote:
Hi
.
Simanchal
On Fri, Jan 31, 2014 at 4:17 AM, David Law-2 [via Apache POI]
ml-node+s1045710n5714785...@n5.nabble.com wrote:
Simanchal,
may I ask a couple of stupid questions?
I've removed some dead code what's left
in the heart of all those nested if's for's is this:
CTRegularTextRun
Could I suggest someone check in the ooxml-schemas sources?
Contrary to what is stated in FAQ 14, they are nowhere to be found.
All the best,
DaveLaw
-
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional
...
Thanks... Dominik.
On Thu, Feb 6, 2014 at 1:00 AM, David Law david@apconsult.de wrote:
Could I suggest someone check in the ooxml-schemas sources?
Contrary to what is stated in FAQ 14, they are nowhere to be found.
All the best,
DaveLaw
Hi Folks,
I can't find 3.10-FINAL in maven.
I suspect this is a configuration issue.
Being completely new to maven, I just installed m2eclipse in Kepler.
The Maven Repositories View then looks like this:
I suspect that may be the wrong
14:18, Nick Burch wrote:
On Fri, 14 Feb 2014, David Law wrote:
I can't find 3.10-FINAL in maven. I suspect this is a configuration
issue.
You should just need to point your maven instance at the regular Maven
Central, there's nothing special needed. POI 3.10 final is present there:
http
, David Law wrote:
I've installed maven using the m2eclipse plugin
but the install doesn't seem to create a settings.xml
seems to just default to:
http://repo.maven.apache.org/maven2
http://repo.maven.apache.org/maven2/org/apache/poi/poi/3.10-FINAL/
The files are there on that server!
I think
been checked-in in some invalid state?
3) maven has a bug?
4) m2eclipse has a bug?
Grateful for any thoughts... :-)
All the best,
DaveLaw
On 14/02/2014 17:15, David Law wrote:
That's a very good point Nick! :-)
Thanks for the URL: I had tried to search the repo,
but was redirected to http
lipse uses!
But, rather than waiting a week, there is a workaround:
if you know the Group Id, Artifact Id Version, these can be
procatively requested.
All the best,
DaveLaw
On 16/02/2014 06:35, David Law wrote:
Hi
a
procatively - proactively
:-)
On 16/02/2014 22:51, David Law wrote:
ok Folks,
so here's the lowdown:
maven central has 2 Indices.
One is updated near-real-time.
The other "legacy index"
Jim,
I used them a couple of years ago.
We created Template Excels filled the sheets with data.
Works fine.
You can also fill hidden sheets use the
data in a Chart on another (visible) sheet.
Hope this helps a bit.
All the best,
DaveLaw
On 20/02/2014 20:18, Jim Talbut wrote:
Hi,
Is
Aram,
what exactly is the problem with JDK 7?
All the best,
DaveLaw
On 04/03/2014 00:43, Aram Mirzadeh wrote:
It's a JDK 7 problem ... if you can recompile with 1.6 it'll work.
On 3/3/2014 4:39 PM, Crocker, David wrote:
Hi,
I'm struggling with the worksheet.autoSizeColumn() method. I've
Hi Zac,
having read the Javadoc, I would suggest you try:
sheet.setColumnWidth({cellnum}, {(int)#ofchars} * 256);
All the best,
DaveLaw
On 07/03/2014 17:53, Zac Morris wrote:
Why would
sheet.setColumnWidth({cellnum},{(int)#ofchars});
...be causing those columns to be hidden?
Because of a
Please note: this may be ok for a comparison, but...
XML DOES NOT NORMALLY CONTAIN NEWLINES
They result in spurious Text nodes.
(which most products simply ignore because they are so common)
Javen O'Neals suggestion to convert to canonical is a much better idea.
Workaround: a newline BEFORE
Hi,
one thing was not quite clear about the original question:
do you actually need the Excel at all?
or is the sole purpose of the exercise just to generate a CSV-File for
your upload?
And even if you do need the Excel, it would seem easier just to change the
Programme to write the CSV as a
Nick,
no idea whether the motivation is performance or just plain convenience,
but is it conceivable one could write each Sheet with a dedicated
Thread to separate WorkBooks & then merge the finished Sheets
into a single WorkBook in a final step?
Would there be any advantage in that?
All the
Hi all,
isn't that what the Eclipse *Export Wizard*...
"Runnable JAR File"
with the option
"Package required libraries into generated JAR"
...does?
It includes a "jarinjarloader" in the JAR.
All the best,
DaveLaw
On 11/02/2018 12:17, Nick Burch wrote:
On Sat, 10 Feb 2018, Marco Lechner -
Hello Andreas,
I think if you check the original XML of your *.xlsx,
you'll find that it contains something like:
0.106691299
This value can be mapped EXACTLY to a double in Java.
So that's what you're getting.
In other cases you may find XML values like:
8.61688004E-2
There
lytical & Java skills.
And I need to find something to take my mind off Boris Johnson & cronies...
All the best,
DaveLaw
On 20/10/2019 22:50, Nick Burch wrote:
On Sun, 20 Oct 2019, David Law wrote:
the Cells have no Format. Take a look at the attached File, cell
F10. Andreas t
Hi Nick,
the Cells have no Format. Take a look at the attached File, cell F10.
Andreas tells me it was entered as 0.1066913 & that's how its displayed
too, although it has no format.
Internally, in the XML, its saved as:
0.106691299
which has an exact Java double representation.
POI
better) :-)
Best regards,
DaveLaw
On 21/10/2019 02:13, Andreas Reichel wrote:
Dear All.
with David's help I have been able to read that XLSX correctly and I
will incorporate the following lines in SQLSHEET (XLSX JDBC driver) in
order to avoid such problems in the future:
// @author David Law
Please see attached (revised) Test Proggy
import java.math.BigDecimal;
import java.math.MathContext;
import java.math.RoundingMode;
import java.util.Arrays;
public class SqlSheetBigDecimal {
private static final String dots;
/**/static {
final String pad
seems to be rather unmaintained.
Who knows if they even accept my pull request.
However, if anyone else stumbles over a similar challenge, even the
documentation by the pull request might help.
Cheers
Andreas
On Mon, 2019-10-21 at 13:21 +0200, David Law wrote:
Hello Andreas,
maybe we should
Hi Andreas,
I tried to create a Spreadsheet to reproduce this but failed.
(it returned double = 0.1066913)
Could you share an example.xslsx with us to demonstrate the behaviour?
All the best,
DaveLaw
On 18/10/2019 04:34, Andreas Reichel wrote:
Dear All,
compliments of the day.
We face some
.experian.com<http://www.experian.com/>
experian
From: David Law
Reply-To: POI Users List
Date: Friday, October 18, 2019 at 1:47 PM
To: "user@poi.apache.org"
Subject: Re: Floating Point Arithmetics, reading 0.1066913 gives
0.106691299
Hi Andreas,
I tried to
Hi folks,
forget Java 11, its neither here nor there.
I recommend a braver leap.
Time for a version hike that we can stay with for years to come.
Java 17 is Long Term Service, that's important.
But, just as important, it is a well-balanced, mature release
where you won't (well, hardly) find
42 matches
Mail list logo