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:
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 apa...@gagravarr.org 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 CellRangeAddressList).
So I can go through each
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 melanie.petros...@pnmac.com
Thanks, Nick!
On Wed, Nov 5, 2014 at 4:05 PM, Nick Burch apa...@gagravarr.org 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 certain, you'll need
Thanks!
On Wed, Nov 5, 2014 at 4:05 PM, Nick Burch apa...@gagravarr.org 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 certain, you'll need to evaluate
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...@pnmac.com melanie.petros
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
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 x7742
blake.wat...@pnmac.com melanie.petros...@pnmac.com
apa...@gagravarr.org 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, to see where the
problem comes in? So try just the offset bit
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 blake.wat...@pnmac.com 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 melanie.petros...@pnmac.com
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 a...@mbcli.com wrote:
Why not just system copy the file?
On Mon, Dec 8, 2014 at 6:56 PM, Blake Watson blake.wat...@pnmac.com
wrote:
Is it possible?
I'm guessing I could
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)/
And, in
OK. And?
On Tue, Dec 9, 2014 at 11:16 AM, Aram Mirzadeh a...@mbcli.com 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 blake.wat...@pnmac.com
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
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 blake.wat...@pnmac.com
wrote:
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
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 apa...@gagravarr.org 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 null
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
Moorpark, CA
the digital signing with poi ? There is a bug :)
On Tue, Feb 24, 2015 at 2:11 AM, Blake Watson blake.wat...@pnmac.com
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 worth tackling
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
(805) 330.4911 x7742
blake.wat...@pnmac.com melanie.petros
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 blake.wat...@pnmac.com
wrote:
I got this error evaluating a cell--which was a big old chained
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 melanie.petros...@pnmac.com
www.PennyMacUSA.com http://www.pennymacusa.com/
...@poi.apache.org
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com melanie.petros...@pnmac.com
www.PennyMacUSA.com http://www.pennymacusa.com/
e me the value of first row,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 <melanie.petros...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
; xlsx(Excel-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 <melanie.petros...@pnmac.com>
w
There is a cache, essentially. Check out:
https://poi.apache.org/apidocs/org/apache/poi/hssf/record/aggregates/MergedCellsTable.html
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 <blake.wat...@pnmac.com>
wrote:
> Is there a way to know, given a
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 <melanie.petros...@pnmac.com>
www.PennyMacUSA.com
> list of Ptgs via the FormulaParser, 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.
>
&
lso 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
Moorpark, CA 93021
(805) 330.4911 x7742
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 <melanie.petros...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
e out if there were a particular
function/field for it.
On Wed, May 25, 2016 at 6:37 PM, Javen O'Neal <javenon...@gmail.com> 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&q
Well, it'll be in Clojure, so... =)
On Wed, Feb 24, 2016 at 2:58 PM, Nick Burch <apa...@gagravarr.org> wrote:
> On Wed, 24 Feb 2016, Blake Watson wrote:
>
>> Thanks for the response, Nick!
>>
>> I guess we'll have to roll our own...
>>
>
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 <apa...@gagravarr.org> wrote:
> On Wed, 24 Feb 2016, Blake Watson wrote:
>
>> So, there's lots of examples on how to write out conditional stuff to
>> Excel f
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 <melanie.petros...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Thanks, Nick. I can do both. =P
On Wed, Mar 30, 2016 at 2:40 PM, Nick Burch <n...@apache.org> 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
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
Moorpark, CA 93021
(805
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
>
--
m 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 incoming
spreadsheets. I don't have to su
>>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
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
, 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
blake.wat...@pnmac.com <melanie.pet
lojure, Kotlin, 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 9
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
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 cell).
--
*Blake Watson
fEvaluator.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 SheetRefEvaluator hasn't been as enlightening as I hoped.
Anyone?
Thanks again, Nick!
On Thu, Oct 6, 2016 at 11:12 AM, Nick Burch <apa...@gagravarr.org> 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 nam
all 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
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 <apa...@gagravarr.org> wrote:
> On Thu, 6 Oct 2016, Blake Watson wrote:
>
>> That's just how Ex
yphenated sheet names are not getting processed correctly.
>
> On Oct 11, 2016 3:16 PM, "Blake Watson" <blake.wat...@pnmac.com> wrote:
>
> > In my Linking External Workbooks subject, I was coming up with a lot of
> > "Invalid sheetIndex: -1" errors, which I was able t
s replaced 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 <melanie.petros...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
_questions_14031208_apache-2Dpoi-2D=DgIBaQ=
> dmLomitc30UP5j2qU8E1rg=p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw=
> ywVjujANmewevZzklsLgayc0tgq6ktSx0CVxUTE6vPc=d3BMEzm5wNOjKZ_
> nQazqhOcq5L5X9v6d5i_TtzxwEuo=
> > rate-formula-inconsistency-with-long-periods/14087532#14087532
> >
>
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" <blake.wat...@pnmac.com> wrote:
>
> > I believe I've found a bug in the RATE implementation. If I call evaluate
> > wit
re 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 <m
Yeah, I'm not complaining. =)
What I do wouldn't be possible without POI. We can splurge on RAM...
he screenshot of memory dump:
> > >
> >
>
> See https://urldefense.proofpoint.com/v2/url?u=http-3A__poi.
> apache.org_spreadsheet_quick-2Dguide.html-23Files-2Bvs-
> 2BInputStreams=DgIFaQ=dmLomitc30UP5j2qU8E1rg=
> p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw=K-mZqLKcau3v
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
---
> 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 <melanie.petros...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
that 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 <melanie.pet
ula strings but I don't see it
> in
> > the FormulaEvaluator class (where I thought I had before).
> >
> > I feel like we might have to use the ?00BFormulaParser to get the Ptg[]
> but
> > I'm not sure what we do at that point.
> >
> > Hints?
> >
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
tml-3Fdev-40poi.apache.org=DwIFaQ=
> dmLomitc30UP5j2qU8E1rg=p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw=
> wWV6I426tfNHSnUny_EWojzjtTbqvnYu-d4NF9JyxQo=
> TqoSy3ICyFrw0yAK-gxrWSn-aI0lt_DlaKz1Ajgje7c=
>
> On Fri, Apr 14, 2017 at 10:37 AM Blake Watson <blake.wat...@pnmac.com>
> wrote:
>
>
impacts I hadn'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 Bl
ing wrapper around the poi spreadsheet api??
> I'd need the following
>
> readRangeAsMatrix
> updateCell
> recalcWorkbook
>
> thanks in advance
> --
>
>
> <i.deiudici...@legalmail.it>
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Co
>> 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
>>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
ok 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 something is a particular type that POI can tell me what t
>>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,
=$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) 330.4911 x7742
blak
I'll give it a shot!
On Tue, Oct 10, 2017 at 11:48 PM, Nick Burch <apa...@gagravarr.org> 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 workb
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
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
? Or
there's something that the conditional formatting isn't catching that it
should?
On Mon, Oct 23, 2017 at 9:57 AM, Blake Watson <blake.wat...@pnmac.com>
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 changin
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
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
VALUE-2Dfunction-
> 2D257d0108-2D07dc-2D437d-2Dae1c-2Dbc2d3953d8c2=DwIFaQ=
> dmLomitc30UP5j2qU8E1rg=p42pHJHEwFZOHtVFHKJUdL2fYbroN3
> 3stXXb3Psthjw=A-h6HE-pwhhmdsnyNXVeQUOADGf5O9XFaA9Ik
> HejQZM=rax8HzzVk34s6HLibxE-gWtf-oeyghcc66PZ2sPOCLU=
>
>
> On Mon, Dec 11, 2017 at 3:34 PM Blake Watson <blake.wat..
s: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 <blake.wat...@pnmac.com>
wrote:
> DATEVALUE isn't currently supported, I realize, too, so...
>
> On Tue, Dec 12, 2017 at 8:59 AM, Greg Woolsey <gre
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.
--
*Blake Watson*
*
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.
ever cell values change. Are you doing this?
> That could be the cause of your error.
>
> On Thu, Oct 19, 2017 at 2:31 PM Blake Watson <blake.wat...@pnmac.com>
> wrote:
>
> > So, in working out the Java for this, I've somehow got myself into a
> > condition where I can't
>
>
> 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.
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
>>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
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/>
---
> 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/>
hat front,
> unfortunately. 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 <blake.wat...@pnmac.com>
>
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 <blake.wat...@pnmac.com> wrote:
> What's weird is, XMLBeans doesn't appear to be any
Never mind. Found it. =)
On Wed, Jan 3, 2018 at 2:34 PM, Blake Watson <blake.wat...@pnmac.com> 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
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 <blake.wat...@pnmac.com> wrote:
> Never mind. Found it. =)
>
> On Wed, Jan 3,
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
ate.
>
> On Tue, Jan 23, 2018 at 1:32 PM Blake Watson <blake.wat...@pnmac.com>
> wrote:
>
> > OK, FWIW, I did this:
> >
> > 1. I get all the rules on the sheet...
> > 2. ...and map the rules to their formatting...
> > 3. ...then call getMatchingCells for
OK, FWIW, I did this:
1. I get all the rules on the sheet...
2. ...and map the rules to their formatting...
3. ...then call getMatchingCells for each rule...
4. ...and create a map of cells to formatting...
5. ...then merge the maps for all rules...
I ended up with a hash-map of cell=>formatting
the century out in Excel, the format seems to be:
m/d/yy;@
Am I missing something or is this a discrepancy?
--
*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/>
This appears to be a bug. I thought maybe it was related to the Windows
locale short-date format, but even that seems to return the century.
On further testing, EVERY date format seems to return m/d/yy, regardless of
the format string.
On Wed, Apr 4, 2018 at 4:26 PM, Blake Watson <blake.
number of
> unit-tests which verify various formats/variations, maybe you can put your
> case into a unit-test as well? That would make it easier to comment if you
> should be using some API differently or if there is indeed a bug here.
>
> Thanks... Dominik.
>
> On Thu
Hi, guys—
Saw a bug about pivot tables and was wondering: Has pivot table support
advanced beyond the "not really supported" level documented on the
"limitations" page?
https://poi.apache.org/spreadsheet/limitations.html
--
*Blake Watson*
*PNMAC*
Application Development
1 - 100 of 105 matches
Mail list logo