moving formulas, or, what version of Poi should I use?

[Ralph Johnson <jo...@cs.uiuc.edu>]

My project has been using Poi 3.6 for a few years to import spreadsheets.
We export CSVs, but for quite a while we have wanted to export our data a
nicely formatted spreadsheets, so I decided to bite the bullet and learn
Poi and do it.   I developed something that lets us take a XLSX file as a
template and then it writes data into it, especially filling in tables.
Filling in tables causes rows to move, which means that the cell references
in the formulas are off.  So, I decided to fix it.

When I started looking for info on changing formulas in Poi, I realized
that 3.6 is woefully out of date and that 3.13 has much better support for
updating cell references when you insert rows.  So, I installed 3.13 and
made sure the system worked with it.   But 3.13 doesn't match the javadocs
I find for Poi on the web.   In particular, the javadoc says that XSSFSheet
has a copyRows method that takes a CellCopyPolicy as an argument, but it
doesn't have that method in 3.13, and I can't find that class.

So, is the javadoc for an older version of Poi?  If so, what do I use
instead of copyRows?   Or is it for a newer version?   If so, which one?

-Ralph Johnson

Re: moving formulas, or, what version of Poi should I use?

[Ralph Johnson <jo...@cs.uiuc.edu>]

Thanks!  I will sign on to the trunk until 3.14 is released.

-Ralph Johnson

On Thu, Nov 5, 2015 at 8:53 AM, Nick Burch <ap...@gagravarr.org> wrote:

> On Thu, 5 Nov 2015, Ralph Johnson wrote:
>
>> When I started looking for info on changing formulas in Poi, I realized
>> that 3.6 is woefully out of date and that 3.13 has much better support for
>> updating cell references when you insert rows.  So, I installed 3.13 and
>> made sure the system worked with it.   But 3.13 doesn't match the javadocs
>> I find for Poi on the web.
>>
>
> JavaDocs on the website refer to trunk. For the javadocs that apply to
> 3.13, those are included in the 3.13 binary download
>
> In particular, the javadoc says that XSSFSheet has a copyRows method that
>> takes a CellCopyPolicy as an argument, but it doesn't have that method in
>> 3.13, and I can't find that class.
>>
>
> Added recently, see the changelog <http://poi.apache.org/changes.html>
> for details
>
> There should hopefully be a 3.14 beta 1 release quite soon, which will be
> the first release with that functionality in. For now, you'd need to
> checkout from svn/git and build yourself
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Re: moving formulas, or, what version of Poi should I use?

[Nick Burch <ap...@gagravarr.org>]

On Thu, 5 Nov 2015, Ralph Johnson wrote:
> When I started looking for info on changing formulas in Poi, I realized
> that 3.6 is woefully out of date and that 3.13 has much better support for
> updating cell references when you insert rows.  So, I installed 3.13 and
> made sure the system worked with it.   But 3.13 doesn't match the javadocs
> I find for Poi on the web.

JavaDocs on the website refer to trunk. For the javadocs that apply to 
3.13, those are included in the 3.13 binary download

> In particular, the javadoc says that XSSFSheet has a copyRows method 
> that takes a CellCopyPolicy as an argument, but it doesn't have that 
> method in 3.13, and I can't find that class.

Added recently, see the changelog <http://poi.apache.org/changes.html> for 
details

There should hopefully be a 3.14 beta 1 release quite soon, which will be 
the first release with that functionality in. For now, you'd need to 
checkout from svn/git and build yourself

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org