Hello, all--
I'm using POI to supply values to a customer created spreadsheet and
present return values, which has worked pretty well so far. I have an issue
where VLOOKUP doesn't work (at least in some cases) if there's no sort
parameter provided.
This doesn't work:
=ROUND(VLOOKUP(State,Assumpt
I'm trying to figure out, as the subject says, whether a cell is in a
particular (not necessarily contiguous) area. Seems like there would be an
existing utility for that, but maybe not.
I'm working with the output of the sheet's getDataValidations method, which
gives me a getRegions (returning a
Thanks, Nick!
On Wed, Oct 22, 2014 at 3:13 AM, Nick Burch wrote:
> On Tue, 21 Oct 2014, Blake Watson wrote:
>
>> I'm working with the output of the sheet's getDataValidations method,
>> which
>> gives me a getRegions (returning a CellRangeAddressLis
Is there a way to ascertain what data type a formula will return? If you
invoke getCellType, you just get "formula".
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA
Thanks, Nick!
On Wed, Nov 5, 2014 at 4:05 PM, Nick Burch wrote:
> On Wed, 5 Nov 2014, Blake Watson wrote:
>
>> Is there a way to ascertain what data type a formula will return? If you
>> invoke getCellType, you just get "formula".
>>
>
> If you need t
Thanks!
On Wed, Nov 5, 2014 at 4:05 PM, Nick Burch wrote:
> On Wed, 5 Nov 2014, Blake Watson wrote:
>
>> Is there a way to ascertain what data type a formula will return? If you
>> invoke getCellType, you just get "formula".
>>
>
> If you need to be
Is it possible, given a cell with (e.g.) a currency format, to pass a value
like "$123,456.00" to set it? Or must we always use 123456?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...
w-Excelfile-tp5717246.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> For additional commands, e-mail: user-h...@poi.apache.org
>
f so, why wouldn't it be in 3.11? Does Google Sheets use POI? (I ask
because it errors out on the formula, too, and says "Parse formula error".)
Thoughts?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7
AM, Nick Burch wrote:
> On Mon, 1 Dec 2014, Blake Watson wrote:
>
>> Got a formula with a pair of ranges:
>>
>> =IFERROR(MATCH(TRUE,OFFSET(Sh1!$L$27,I20,0):'Sh1'!$L$38,0)+I20,"false")
>>
>
> Can you try breaking that down into individual bits
By "all", I mean: Nick.
Reminding me that I could parse the formula in a debugger and examine the
results is what clued me in.
On Tue, Dec 2, 2014 at 1:59 PM, Blake Watson wrote:
> OK, false alarm. Everything's parsing fine. The problem was somewhere
> else entirely.
&
OK, false alarm. Everything's parsing fine. The problem was somewhere else
entirely.
Thanks all for the help.
Is it possible?
I'm guessing I could create a new workbook and clone all the sheets but I'm
worried I might miss something.
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA
Because it's in memory, and I need a fresh copy every few seconds. =P
On Tue, Dec 9, 2014 at 12:30 AM, Aram Mirzadeh wrote:
> Why not just system copy the file?
>
> On Mon, Dec 8, 2014 at 6:56 PM, Blake Watson
> wrote:
>
> > Is it possible?
> >
> > I&#x
OK, I'm not describing this clearly. I have a workbook (W) on a server. A
user provides inputs which are fed into (W) to create a new version of (W).
(W)=>(I)=>(O)
But I have many users accessing (W), all with their own (I)s:
|//>(I)\
|/>(I)\\
(W)===>(I)=(O)
|\>(I)//
|\\>(I)/
An
OK. And?
On Tue, Dec 9, 2014 at 11:16 AM, Aram Mirzadeh wrote:
> It's still a POJO, no matter how fast or how many copies you need.
>
> On Tue, Dec 9, 2014 at 11:56 AM, Blake Watson
> wrote:
>
> > Because it's in memory, and I need a fresh copy every few seconds.
Hello--
I'm still looking for a way to copy a spreadsheet in memory and have some
assurance that it's a fully functioning, legit copy.
My situation is that I pull up a spreadsheet in a web server, then put up a
browser front end that allows users to populate that spreadsheet. This, of
course
f of that. Unless the workbook is large or complex it
> should not take too long to build the Workbook from the byte[]...
>
> Dominik.
>
> On Tue, Jan 20, 2015 at 10:38 PM, Blake Watson
> wrote:
> >
> > Hello--
> >
> >
> > I'm still looking for a
So, I hit my first unimplemented function: DateDif
I'm curious as to why it's not implemented. Just a bunch of ugly code
nobody felt was worth tackling? Or is there something more complex in its
features?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Mo
with poi ? There is a bug :)
>
> On Tue, Feb 24, 2015 at 2:11 AM, Blake Watson
> wrote:
>
> > So, I hit my first unimplemented function: DateDif
> >
> > I'm curious as to why it's not implemented. Just a bunch of ugly code
> > nobody felt was wor
e
undefined.
For experimental purposes only. I'm not sure how I'll ultimately handle
this.
Just curious if anyone has run into either of these, and how they handled
it.
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(80
Wait, I was mistaken. "Empty" does not work. Using a named range called
"null" works, of course, though I'm not sure of the implications thereof.
On Thu, Feb 26, 2015 at 3:03 PM, Blake Watson
wrote:
> I got this error evaluating a cell--which was a big old chained IF
Nick--
What am I looking for? Are null/undefined/Empty supposed to be supported?
===Blake===
On Thu, Feb 26, 2015 at 8:34 PM, Nick Burch wrote:
> On Thu, 26 Feb 2015, Blake Watson wrote:
>
>> I got this error evaluating a cell--which was a big old chained IF that
>> return &
have any way to "compress" or otherwise clean up a workbook?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
What do people do with embedded SQL queries in Excel sheets?
(I just got handed a sheet that loads from two MSSQL tables.)
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <h
ser mailing list archive at Nabble.com.
> >
> > -----
> > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> > For additional commands, e-mail: user-h...@poi.apache.org
> >
> >
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Is there a way to know, given a formula, what cells and named ranges are
used by that formula? I know there's the internal "parse" routine but
that's both internal and somewhat more primitive than I was hoping for.
--
*Blake Watson*
*PNMAC*
Application Development Manag
No suggestions? I'm looking for a way to say "If this cell (or set of
cells) has changed, this other cell (or set of cells) are dependent and
must be re-evaluated."
On Tue, Sep 22, 2015 at 8:00 AM, Blake Watson
wrote:
> Is there a way to know, given a formula, what cells an
w,colon of the cell(i mean merged cell value)
>
> ThankYou
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
There is a cache, essentially. Check out:
https://poi.apache.org/apidocs/org/apache/poi/hssf/record/aggregates/MergedCellsTable.html
2007) files as i have seen most of the people are saying to use
> different for different format
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
o use this.
I don't want to build an Excel formula parser, that's why I use POI. So
what do I do?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
er, then you'll need to look through
> these and handle any Ref-type-Ptg to find out which Cell(s) it
> references.
>
> XSSFEvaluationWorkbook.create(wb);
> Ptg[] ptgs = FormulaParser.parse(formula, fpb, formulaType, sheetIndex);
>
> Dominik.
>
> On Wed, Dec 9, 2015
.
And I suppose that also explains why it's not in POI: The newness (maybe?),
the extra work, and the fact that other validation aspects may rely on the
range-in-same-sheet-or-named logic.
===Blake===
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Mo
ay? IOW, POI doesn't directly/automatically support conditional formatting
triggered by changes made to an XSSFCell?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Thanks for the response, Nick!
I guess we'll have to roll our own...
On Wed, Feb 24, 2016 at 2:42 PM, Nick Burch wrote:
> On Wed, 24 Feb 2016, Blake Watson wrote:
>
>> So, there's lots of examples on how to write out conditional stuff to
>> Excel files.
>>
Well, it'll be in Clojure, so... =)
On Wed, Feb 24, 2016 at 2:58 PM, Nick Burch wrote:
> On Wed, 24 Feb 2016, Blake Watson wrote:
>
>> Thanks for the response, Nick!
>>
>> I guess we'll have to roll our own...
>>
nt to remove the date formatting
> regardless of the cell type. But I cannot detect that it is a date unless I
> enter a numeric value in the cell.
>
> Does anyone have a tip as to how I can detect date formatting without
> requiring a value in the cell?
>
> /Bengt
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
be wise to add an
> extra parameter indicating whether the cell's value should be checked as
> well or if it is just a format check. The old version (with just the Cell
> parameter) could still exist but call the new method with a second
> parameter indicating that the cell's va
y hint of the actual
sources and cannot instantiate the 1CvfoList or 1ColorList.
This would seem to be a dead-end as far as using these for figuring out
what conditions apply to a cell. Can anyone help with this?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moo
he unit tests to drag
> them over
>
How is it they can start with a numeral?
> Otherwise, build a spreadsheet like you want in excel, save, unzip the
> .xlsx and read the xml to see what's needed!
>
>
The problem with that approach is that I don't have control over i
Thanks, Nick. I can do both. =P
On Wed, Mar 30, 2016 at 2:40 PM, Nick Burch wrote:
> On Tue, 29 Mar 2016, Blake Watson wrote:
>
>> I did a bit of stuff on it, enough to solve a $DAYJOB need, then stopped
>>> again. Creation and Reading should both cover most things you want
t, but it's possible, of course, that I
misunderstand what's going on.
2) Isn't that, essentially, a bug? Shouldn't the eval return what Excel
would return?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
bla
>>because the creation of workbook instances is pretty costly (about 200ms
to 15 seconds for the workbooks we are dealing with) we implemented a
pooling of workbook instances which seems to work pretty well.<<
This is what I did, as well.
>>Since we are only performing limited write-operations on
I am doing exactly what Kai is, with the specification that the user input
and output can come from web representations (or RESTfully) of the
spreadsheet, so POI isn't exactly involved in those. (I used the To-HTML
example from Ken Arnold—and what a treat to run into one of the fathers of
Rogue her
with one called "Sheet2 (BALLOON PAYMENT LOAN)".
Can I get the "Sheet2" attribute, whatever it's called?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
figure out if there were a particular
function/field for it.
On Wed, May 25, 2016 at 6:37 PM, Javen O'Neal wrote:
> XSSF or HSSF? If XSSF, have you looked inside the XML files to see if the
> internal name is there?
> On May 25, 2016 3:24 PM, "Blake Watson" wrote:
>
>
1) Ensure I only save relevant sheets/cells from the files (to speed up
retrieval/parsing)
2) Override parsing in XSSFWorkbook to avoid unnecessary work such as
themes, styles etc
3) Pool the workbooks to avoid creating them every time (even though I need
to be able to update them separately for ev
and anything else that can run
> POI code.
>
> Also, if anyone is using Ruby, the POI Ruby page could probably use an
> update. https://poi.apache.org/poi-ruby.html
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x77
org.apache.poi.ss.formula.SheetRefEvaluator.
(SheetRefEvaluator.java:36)
I've also tried putting in "[1]" or "1" in the map rather than my
spreadsheet name. I don't see in all this how the spreadsheet name in Excel
comes out as "[1]" in POI.
Looking at Sh
with a small junit
> unit test, and we'll take a look
>
> The simple case doesn't return this so I must have introduced another
issue. If it recurs and I can recreate, I'll file a bugzilla report.
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Thanks again, Nick!
On Thu, Oct 6, 2016 at 11:12 AM, Nick Burch wrote:
> On Thu, 6 Oct 2016, Blake Watson wrote:
>
>> That's just how Excel stores it for XLSX files. The link table provides
>>> the mapping between those indexes and the names shown in Excel. When POI
it means I can keep formula evaluators cached as references without caring
whether other threads might change the base workbooks for their own
purposes.)
On Thu, Oct 6, 2016 at 11:12 AM, Nick Burch wrote:
> On Thu, 6 Oct 2016, Blake Watson wrote:
>
>> That's just how Excel sto
;. Sure enough, by the rules, that
should be legit.
So, what am I missing? Is it just that it's one thing to create references
and another to read them?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
are not getting processed correctly.
>
> On Oct 11, 2016 3:16 PM, "Blake Watson" wrote:
>
> > In my Linking External Workbooks subject, I was coming up with a lot of
> > "Invalid sheetIndex: -1" errors, which I was able to trace to a sheet
&
laced with quotes. Might be worth documenting somewhere. =P
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
't match (and is suddenly tiny).
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
The only thing missing for this bug is some unit tests. Would you be
> willing to write up some unit tests and upload to this bug?
>
> On Nov 22, 2016 4:15 PM, "Blake Watson" wrote:
>
> > I believe I've found a bug in the RATE implementation. If I call evaluate
>
nse.proofpoint.com/v2/url?u=http-3A__
> stackoverflow.com_questions_14031208_apache-2Dpoi-2D&d=DgIBaQ&c=
> dmLomitc30UP5j2qU8E1rg&r=p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> ywVjujANmewevZzklsLgayc0tgq6ktSx0CVxUTE6vPc&s=d3BMEzm5wNOjKZ_
> nQazqhOcq5L5X9v6d
owing
> > > is the screenshot of memory dump:
> > >
> >
>
> See https://urldefense.proofpoint.com/v2/url?u=http-3A__poi.
> apache.org_spreadsheet_quick-2Dguide.html-23Files-2Bvs-
> 2BInputStreams&d=DgIFaQ&c=dmLomitc30UP5j2qU8E1rg&r=
> p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&am
Yeah, I'm not complaining. =)
What I do wouldn't be possible without POI. We can splurge on RAM...
rce at the same time.
I have not been able to create this situation, however. Excel seems to
insist that data validation be applied uniformly within a region. I'm not
complaining, I'm just trying to figure out if it's something I should look
for (more than one validation per c
ard =creating=
Excel workbooks and thisi s more about =interpreting= Excel workbooks.
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Nick--
Thanks!
Arrays.asList(
>DataValidationEvaluator.getValidationForCell(ref).
> getValidationConstraint().getExplicitListValues()
> ).contains(value)
>
> should get you almost all the way there, I think?
I think you may be overestimating getExplicitListValues(). =) It handles
o
>
>
>
> Hmm, sounds like we need an extra method on DataValidationEvaluator or
> similar class to handle all these other cases then!
>
>
I think so. I'm hoping I can get to a point so that late spring/early
summer I can start pushing some stuff back. POI has been tremendously
helpful for us.
o unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> For additional commands, e-mail: user-h...@poi.apache.org
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
at are
not in cells.
I feel like we might have to use the FormulaParser to get the Ptg[] but
I'm not sure what we do at that point.
Hints?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyM
> sZivWcpGP0RZpgUoZ-pF5ZmMxwdRos3CNST2LsA&e=
>
> > All of the evaluation stuff I can find works on a Cell object. I thought
> I
> > had seen something for evaluation of formula strings but I don't see it
> in
> > the FormulaEvaluator class
7;t thought of, reworked the patch,
> submitted it, and had it applied. My work got what it needed, open source
> got better, and the end product was better than my individual efforts
> alone, a multiplier my boss could understand.
>
> On Fri, Apr 14, 2017 at 9:43 AM Blake Watson
&g
ache.org&d=DwIFaQ&c=
> dmLomitc30UP5j2qU8E1rg&r=p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> wWV6I426tfNHSnUny_EWojzjtTbqvnYu-d4NF9JyxQo&s=
> TqoSy3ICyFrw0yAK-gxrWSn-aI0lt_DlaKz1Ajgje7c&e=
>
> On Fri, Apr 14, 2017 at 10:37 AM Blake Watson
> wrote:
>
> > Well,
Greg,
I'm having trouble figuring out how to use the conditional stuff. I can't
seem to =find= ConditionalFormattingEvaluator in the POI jar.
If I could find it, I'm not sure how I'd use it:
ec = ConditionalFormattingEvaluator(Workbook wb, WorkbookEvaluatorProvider
provider);
How do I create
t; > ConditionalFormattingEvaluator(workbook, wbEvalProv);
> > // if cell values have changed, clear cached format results
> > cfEvaluator.clearAllCachedValues();
> > List rules =
> > cfEvaluator.getConditionalFormattingForCell(cell);
> > // check rules list for null, do what you want with r
;s a number. It's just a
string that happens to look like a number.
But then I realized that blanks all come out as, well, blank (or
CellType/BLANK rather). Do I have to suss the type from the format manually
to get the type they mean? Is there any way for them to specify in Excel
that som
>>Are you after the Cell's CellStyle's DataFormat?
No, that would be the "#,##0.00", which I have. I want to get from the
DataFormat to the type (numeric, string, etc.). I think I'll have to do it
myself.
>> but doesn't mean that's what will be written there.
Not in Excel-land. This presents some challenges when you're trying to
actually restrict what might go there.
>>You could try entering a date and format it as "#,##0.00".
Yeah. And I could format the values according to whats in there, which
>> I don't think you can restrict what goes in a cell in Excel without
using VBA.
You can if you're only accessing the cell through POI, which I am. =)
>>If you need to do that you are better off with a database anyway.
I guess I'm using POI differently than most. For me, it's a way for people
w
>>You may be better served having users define data validation constraints
I do use that. It helps with keeping the data correct, but has no effect on
how the data acts when exported.
In Excel, you can type '1 to mean "the string 1" but then you can turn
around and put a plain 1 in the same cell,
he poi spreadsheet api??
> I'd need the following
>
> readRangeAsMatrix
> updateCell
> recalcWorkbook
>
> thanks in advance
> --
>
>
>
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805)
mple:
=$O11=0
=$E11=0
I did find some date-based conditionals (the only thing I could think that
would cause the error) so I removed those and I'm still getting the errors.
Any thoughts?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805)
I'll give it a shot!
On Tue, Oct 10, 2017 at 11:48 PM, Nick Burch wrote:
> On Tue, 10 Oct 2017, Blake Watson wrote:
>
>> I'm trying to create a simplest example of this but I have a situation
>> where I:
>>
>> 1. Load a workbook with a conditional.
I'm using 3.17 and working on a simplest possible case. There's something
about this particular sheet that seems to be causing an issue and I haven't
figured out what yet. It's on a sheet with four conditional aspects in toto
and two of the formats are white-on-white (basically making text
invisibl
I'll try the tests thing following Nick's steps. I'm sure I didn't do that
in that order.
As far as the conditionals go, I've got the spreadsheet down to two pages.
The error occurs on the Page A—but it goes away if I eliminate Page B.
I don't have the full stack trace at the moment.(I can't reme
I've attached a greatly reduced version of the spreadsheet. About 15 cells
with one conditional. I've tried to reduce it further but can't seem to do
it without altering the error. Actually, that might be important. Most of
my tweaks, if they don't fix the problem, result in:
NullPointerException
>
>
> * Ensure you're on a version of Eclipse that supports Java 8
> * Checkout from svn / git
> * On the command line, do "ant compile" to have dependencies fetched
> * In Eclipse, do Import -> General -> Existing Project into Workspace
> * Point it at your checkout
> * Wait for the build to
>
>
> Could you open a bug in bugzilla, upload the file, and a snippet of code
> needed to reproduce the error? It's much less likely to get lost /
> forgotten on bugzilla than email!
>
I'm tryin', Nick! I'm not really a Java guy so it's taking me a while to
get set up.
So, in working out the Java for this, I've somehow got myself into a
condition where I can't even open the workbook (in Java). When I step
through this:
FileInputStream fis = new FileInputStream("condfail.xlsx");
Workbook wb = new XSSFWorkbook(fis);
I got a NoClassDefFoundError.
Exception in thr
e you doing this?
> That could be the cause of your error.
>
> On Thu, Oct 19, 2017 at 2:31 PM Blake Watson
> wrote:
>
> > So, in working out the Java for this, I've somehow got myself into a
> > condition where I can't even open the workbook (in Java).
OK: I was not doing it for my example, but adding it in didn't change
anything. I am creating a cell object, but I'm not changing any values (or
formats).
I was able to open the file as well, after some fussing around. I think it
was just something I didn't get about FileInputStream. So I now have
there's something that the conditional formatting isn't catching that it
should?
On Mon, Oct 23, 2017 at 9:57 AM, Blake Watson
wrote:
> OK: I was not doing it for my example, but adding it in didn't change
> anything. I am creating a cell object, but I'm not changing any valu
Yeah, I feel like I should be able to create a simple example that doesn't
use the conditional stuff so far but haven't been able to change it much
without, uh, brekaing the brokenness. So I think there's something catching
the issue in most cases.
tion) for Value, it seems as though POI expects a non-date number.
There's also DateValue, of course.
I think, Value should evaluate as Excel's VALUE function does. Unless I
miss something. In any event, VALUE in a cell should be something that POI
should be able to catch.
--
*B
2D437d-2Dae1c-2Dbc2d3953d8c2&d=DwIFaQ&c=
> dmLomitc30UP5j2qU8E1rg&r=p42pHJHEwFZOHtVFHKJUdL2fYbroN3
> 3stXXb3Psthjw&m=A-h6HE-pwhhmdsnyNXVeQUOADGf5O9XFaA9Ik
> HejQZM&s=rax8HzzVk34s6HLibxE-gWtf-oeyghcc66PZ2sPOCLU&e=
>
>
> On Mon, Dec 11, 2017 at 3:34 PM
eturns:a double representing the (integer) number of days since the start
of the Excel epoch
On Tue, Dec 12, 2017 at 1:56 PM, Blake Watson
wrote:
> DATEVALUE isn't currently supported, I realize, too, so...
>
> On Tue, Dec 12, 2017 at 8:59 AM, Greg Woolsey
> wrote:
>
>> This
eet were all going to ask the same question.
But am I even using the right class in the right way?
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
>>Could this be related to bug #61841 - Unnecessary long computation when
>>evaluating
VLOOKUP on all column reference?
A quick removal of the VLOOKUPs in the spreadsheet would seem to indicate
that that is not the issue. (I'm not great at Excel, heh, but a workbook
search for VLOOKUP turns up
I dropped the JARs into my Maven directories which almost seemed to work,
but I'm getting ClassNotFoundException for org.apache.xmlbeans.XMLObject.
Maybe related to 59268
? I see the xmlbeans jar in the package but if I swap it out for the
existing xmlbeans-2.6.0.jar that doesn't seem to change
fortunately. I know folks have had various issues and questions about
> XMLBeans and classpath issues on the mailing list and StackOverflow,
> though, so you may find some answers in those archives.
>
> On Tue, Jan 2, 2018 at 2:29 PM Blake Watson
> wrote:
>
> > I dropped th
The POM for 3.17 doesn't include XMLBeans or Commons-Collections4.
What happened to CELL_TYPE_FORMULA? Is there a list of changes for 4?
On Tue, Jan 2, 2018 at 9:44 PM, Blake Watson wrote:
> What's weird is, XMLBeans doesn't appear to be any different in the
> downloaded
Never mind. Found it. =)
On Wed, Jan 3, 2018 at 2:34 PM, Blake Watson wrote:
> The POM for 3.17 doesn't include XMLBeans or Commons-Collections4.
>
> What happened to CELL_TYPE_FORMULA? Is there a list of changes for 4?
>
> On Tue, Jan 2, 2018 at 9:44 PM, Blake Watson
OK. *Phew* Got it all working nd...it has no impact on the speed. So
I'm going to go back and see if I can't find the issue in the conditional
stuff.
On Wed, Jan 3, 2018 at 2:41 PM, Blake Watson wrote:
> Never mind. Found it. =)
>
> On Wed, Jan 3, 2018 at 2:34 PM, Bl
1 - 100 of 112 matches
Mail list logo
