Re: shiftrows() in xls document containing hidden (zero height) rows

[discreta discrecion]

How can I unsuscribe?


De: Spyros Rokopanos 
Enviado: sábado, 7 de enero de 2017 15:04:48
Para: user@poi.apache.org
Asunto: Re: shiftrows() in xls document containing hidden (zero height) rows

I don't know if its universal. I have faced the issue in one workbook in which 
one sheet has hidden rows... I have not tried with other workbooks/sheets..
Also from stackoverflow  I found this which sounds the same problem:
"Somehow I manage to create new rows between two rows in an existing excel 
file. The problem is, some of the formatting were not include along the 
shifting of the rows.

One of this, is the row that are hide are not relatively go along during the 
shift. What I mean is(ex.), rows from 20 to 30 is hidden, but when a create new 
rows the formating still there. The hidden rows must also move during the 
insertion/creation of new rows, it should be 21 to 31.

Another thing is, the other object in the sheet that are not in the cell. Like 
the text box are not move along after the new row is created. Its like the 
position of these object are fixed. But I want it to move, the same thing as I 
insert a new row or paste row in excel. If there is a function of inserting a 
new row, please let me know."

Although there are many answers, it seems that problem is unresolved... The 
link is here:
http://stackoverflow.com/questions/5785724/how-to-insert-a-row-between-two-rows-in-an-existing-excel-with-hssf-apache-poi

I will also attach my workbook to have a look...
On 2017-01-06 06:50 (+0200), "Javen O'Neal"  wrote:
> Does this happen on all XLS workbooks or just a few?
>
> If it isn't universal, could you also attach a small workbook to go along
> with your code sample so that we can reproduce the problem?
>
> On Jan 5, 2017 20:47, "Javen O'Neal"  wrote:
>
> Sounds like a bug in the shiftRows code.
>
> Could you post a self-contained example of what you're doing that's causing
> the error, including a stack trace of the error if you're getting an
> exception instead of a mangled workbook?
>
> On Jan 5, 2017 15:40, "Spyros Rokopanos"  wrote:
>
> > Hello all,
> >
> >
> > I would like to ask if behavior of shiftrows() changes if a documents
> > contains hidden (zero height) rows. I just ask because I am trying to
> > insert some new rows (using shiftrows()) and if I have hidden rows in the
> > document I face issues. If I unhide them, shiftrows() works as expected.
> >
> >
> > Has anyone faced a similar issue?
> >
> >
> > Thanks in advance for any hint/help!
> >
> >
> > Kind regards,
> >
> > Spyros
> >
>

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

Re: shiftrows() in xls document containing hidden (zero height) rows

[discreta discrecion]

unsuscribe, please?


De: Spyros Rokopanos 
Enviado: sábado, 7 de enero de 2017 15:04:48
Para: user@poi.apache.org
Asunto: Re: shiftrows() in xls document containing hidden (zero height) rows

I don't know if its universal. I have faced the issue in one workbook in which 
one sheet has hidden rows... I have not tried with other workbooks/sheets..
Also from stackoverflow  I found this which sounds the same problem:
"Somehow I manage to create new rows between two rows in an existing excel 
file. The problem is, some of the formatting were not include along the 
shifting of the rows.

One of this, is the row that are hide are not relatively go along during the 
shift. What I mean is(ex.), rows from 20 to 30 is hidden, but when a create new 
rows the formating still there. The hidden rows must also move during the 
insertion/creation of new rows, it should be 21 to 31.

Another thing is, the other object in the sheet that are not in the cell. Like 
the text box are not move along after the new row is created. Its like the 
position of these object are fixed. But I want it to move, the same thing as I 
insert a new row or paste row in excel. If there is a function of inserting a 
new row, please let me know."

Although there are many answers, it seems that problem is unresolved... The 
link is here:
http://stackoverflow.com/questions/5785724/how-to-insert-a-row-between-two-rows-in-an-existing-excel-with-hssf-apache-poi

I will also attach my workbook to have a look...
On 2017-01-06 06:50 (+0200), "Javen O'Neal"  wrote:
> Does this happen on all XLS workbooks or just a few?
>
> If it isn't universal, could you also attach a small workbook to go along
> with your code sample so that we can reproduce the problem?
>
> On Jan 5, 2017 20:47, "Javen O'Neal"  wrote:
>
> Sounds like a bug in the shiftRows code.
>
> Could you post a self-contained example of what you're doing that's causing
> the error, including a stack trace of the error if you're getting an
> exception instead of a mangled workbook?
>
> On Jan 5, 2017 15:40, "Spyros Rokopanos"  wrote:
>
> > Hello all,
> >
> >
> > I would like to ask if behavior of shiftrows() changes if a documents
> > contains hidden (zero height) rows. I just ask because I am trying to
> > insert some new rows (using shiftrows()) and if I have hidden rows in the
> > document I face issues. If I unhide them, shiftrows() works as expected.
> >
> >
> > Has anyone faced a similar issue?
> >
> >
> > Thanks in advance for any hint/help!
> >
> >
> > Kind regards,
> >
> > Spyros
> >
>

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

Using Apache POI on Hadoop/Spark

[Jörn Franke]

Dear all,

I released a first version of an open source library that uses Apache POI
to read/write Excel files on Hadoop/Spark/etc.:
https://snippetessay.wordpress.com/2017/01/08/readingwriting-excel-documents-with-the-hadoopoffice-library-on-hadoop-and-spark-first-release/


Feel free to comment or propose suggestions via Github issues.

Thank you!

best regsards

Re: shiftrows() in xls document containing hidden (zero height) rows

[Javen O'Neal]

To unsubscribe, send a short message to the mailer daemon:
user-unsubscr...@poi.apache.org

To manage other mailing list preferences, see
https://poi.apache.org/mailinglists.html


On Jan 8, 2017 02:53, "discreta discrecion"  wrote:

unsuscribe, please?


De: Spyros Rokopanos 
Enviado: sábado, 7 de enero de 2017 15:04:48
Para: user@poi.apache.org
Asunto: Re: shiftrows() in xls document containing hidden (zero height) rows

I don't know if its universal. I have faced the issue in one workbook in
which one sheet has hidden rows... I have not tried with other
workbooks/sheets..
Also from stackoverflow  I found this which sounds the same problem:
"Somehow I manage to create new rows between two rows in an existing excel
file. The problem is, some of the formatting were not include along the
shifting of the rows.

One of this, is the row that are hide are not relatively go along during
the shift. What I mean is(ex.), rows from 20 to 30 is hidden, but when a
create new rows the formating still there. The hidden rows must also move
during the insertion/creation of new rows, it should be 21 to 31.

Another thing is, the other object in the sheet that are not in the cell.
Like the text box are not move along after the new row is created. Its like
the position of these object are fixed. But I want it to move, the same
thing as I insert a new row or paste row in excel. If there is a function
of inserting a new row, please let me know."

Although there are many answers, it seems that problem is unresolved... The
link is here:
http://stackoverflow.com/questions/5785724/how-to-
insert-a-row-between-two-rows-in-an-existing-excel-with-hssf-apache-poi

I will also attach my workbook to have a look...
On 2017-01-06 06:50 (+0200), "Javen O'Neal"  wrote:
> Does this happen on all XLS workbooks or just a few?
>
> If it isn't universal, could you also attach a small workbook to go along
> with your code sample so that we can reproduce the problem?
>
> On Jan 5, 2017 20:47, "Javen O'Neal"  wrote:
>
> Sounds like a bug in the shiftRows code.
>
> Could you post a self-contained example of what you're doing that's
causing
> the error, including a stack trace of the error if you're getting an
> exception instead of a mangled workbook?
>
> On Jan 5, 2017 15:40, "Spyros Rokopanos"  wrote:
>
> > Hello all,
> >
> >
> > I would like to ask if behavior of shiftrows() changes if a documents
> > contains hidden (zero height) rows. I just ask because I am trying to
> > insert some new rows (using shiftrows()) and if I have hidden rows in
the
> > document I face issues. If I unhide them, shiftrows() works as expected.
> >
> >
> > Has anyone faced a similar issue?
> >
> >
> > Thanks in advance for any hint/help!
> >
> >
> > Kind regards,
> >
> > Spyros
> >
>

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

Re: shiftrows() in xls document containing hidden (zero height) rows

[Javen O'Neal]

The attachment didn't make it through.

Would you be willing to open a bug on bz.apache.org/bugzilla and submit all
the information needed to reproduce the problem there?

Also include a link to this discussion,
https://lists.apache.org/thread.html/7a2c9215bbc77549c5cf038dac820312f633468ab4f1a5112136c095@


On Jan 7, 2017 18:31, "Spyros Rokopanos"  wrote:

> I don't know if its universal. I have faced the issue in one workbook in
> which one sheet has hidden rows... I have not tried with other
> workbooks/sheets..
> Also from stackoverflow  I found this which sounds the same problem:
> "Somehow I manage to create new rows between two rows in an existing excel
> file. The problem is, some of the formatting were not include along the
> shifting of the rows.
>
> One of this, is the row that are hide are not relatively go along during
> the shift. What I mean is(ex.), rows from 20 to 30 is hidden, but when a
> create new rows the formating still there. The hidden rows must also move
> during the insertion/creation of new rows, it should be 21 to 31.
>
> Another thing is, the other object in the sheet that are not in the cell.
> Like the text box are not move along after the new row is created. Its like
> the position of these object are fixed. But I want it to move, the same
> thing as I insert a new row or paste row in excel. If there is a function
> of inserting a new row, please let me know."
>
> Although there are many answers, it seems that problem is unresolved...
> The link is here:
> http://stackoverflow.com/questions/5785724/how-to-
> insert-a-row-between-two-rows-in-an-existing-excel-with-hssf-apache-poi
>
> I will also attach my workbook to have a look...
> On 2017-01-06 06:50 (+0200), "Javen O'Neal"  wrote:
> > Does this happen on all XLS workbooks or just a few?
> >
> > If it isn't universal, could you also attach a small workbook to go along
> > with your code sample so that we can reproduce the problem?
> >
> > On Jan 5, 2017 20:47, "Javen O'Neal"  wrote:
> >
> > Sounds like a bug in the shiftRows code.
> >
> > Could you post a self-contained example of what you're doing that's
> causing
> > the error, including a stack trace of the error if you're getting an
> > exception instead of a mangled workbook?
> >
> > On Jan 5, 2017 15:40, "Spyros Rokopanos" 
> wrote:
> >
> > > Hello all,
> > >
> > >
> > > I would like to ask if behavior of shiftrows() changes if a documents
> > > contains hidden (zero height) rows. I just ask because I am trying to
> > > insert some new rows (using shiftrows()) and if I have hidden rows in
> the
> > > document I face issues. If I unhide them, shiftrows() works as
> expected.
> > >
> > >
> > > Has anyone faced a similar issue?
> > >
> > >
> > > Thanks in advance for any hint/help!
> > >
> > >
> > > Kind regards,
> > >
> > > Spyros
> > >
> >
>
> -
> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> For additional commands, e-mail: user-h...@poi.apache.org
>
>

Re: Writing workbooks with linked workbooks using XSSFWorkbook

[Dominik Stadler]

Hi,

Unfortunately this is likely to stay unsupported until somebody comes up
with the necessary changes. None of the few active devs is currently
working on this as far as I see, though. Patches are always welcome if you
managed to take a closer look yourself.

Dominik.

On Tue, Jan 3, 2017 at 9:06 PM, Jörn Franke  wrote:

> oh btw. you do not need a Hadoop installation to run the tests, they are
> simple unit tests.
> Simply clone https://github.com/ZuInnoTe/hadoopoffice.git
> Remove all the @Ignore tags from
> *
> fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapred/
> OfficeFormatHadoopExcelTest.java
> * fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapreduce/
> OfficeFormatHadoopExcelTest.java
>
> Go to the fileformat. Run gradle clean build
>
> On Tue, Jan 3, 2017 at 9:03 PM, Jörn Franke  wrote:
>
> > Hi,
> >
> > sorry I was a little bit late. I tried with 82 and still the same error:
> >
> > java.lang.RuntimeException: Not Implemented - see bug #57184
> >
> >
> > I do have a unit test, but it contains a lot of Hadoop stuff. Basically
> this line fails with the message above:
> >
> > currentWorkbook.linkExternalWorkbook(name,currentLinkedWorkbookParser.
> getCurrentWorkbook());
> >
> >
> > I can clearly see in the source code of XSSFWorkbook that
> linkExternalWorkbook simply throws a runtime Exception.
> >
> > The only thing that i want to do - and which works with the Excel2003
> .xls format - is to add an external workbook to the current workbook, refer
> in a formula to it, e.g. via [linkedwbfile.xlsx]Sheet1!B1. Even if do not
> use linkExternalWorkbook, but only setupReferencedWorkbooks then i get a
> null pointer exception when setting the formula referring to an external
> workbook in the cell. Again this is only for XSSFWorkbook when
> modifying/adding cells. HSSFWorkbook works fine.
> >
> > I assume the formula evaluator of XSSFWorkbook simply does not
> understand formulas with external workbook references.
> >
> >
> > Let me know if I can do further analysis to solve the issue.
> >
> > thank you a lot.
> >
> > Best regards
> >
> >
> > On Sat, Dec 31, 2016 at 6:00 PM, Dominik Stadler  >
> > wrote:
> >
> >> Hi,
> >>
> >> Bug 60219 was not fixed yet, but it is now.
> >>
> >> Can you re-try with a recent build from trunk or use the binaries from
> >> https://builds.apache.org/view/POI/job/POI-DSL-1.6/65/ when it
> finishes.
> >>
> >> Thanks... Dominik.
> >>
> >> On Tue, Dec 27, 2016 at 5:21 PM, Jörn Franke 
> >> wrote:
> >>
> >> > There is already a bug report, see my message.
> >> >
> >> > > On 27 Dec 2016, at 17:15, Murphy, Mark 
> >> > wrote:
> >> > >
> >> > > If you create an issue in bugzilla with a unit test, It will be
> easier
> >> > to get that fixed.
> >> > >
> >> > > -Original Message-
> >> > > From: Jörn Franke [mailto:jornfra...@gmail.com]
> >> > > Sent: Tuesday, December 27, 2016 9:53 AM
> >> > > To: user@poi.apache.org
> >> > > Subject: Writing workbooks with linked workbooks using XSSFWorkbook
> >> > >
> >> > > Dear all,
> >> > >
> >> > > I am currently writing an open source library for reading/writing
> >> office
> >> > files on Hadoop/Spark/Hive/etc. The code is on Github and an official
> >> > release in form of a library on maven central will follow soon.
> >> > > The Excel files will be supported by the Apache POI library (3.15).
> >> > > So far everything works quiet well, such as reading from linked
> >> > workbooks (HSSF & XSSF), writing workbooks with linked workbooks
> (HSSF).
> >> > However, I have some issues with writing workbooks with linked
> workbooks
> >> > using XSSF. I receive the following exception (when calling
> >> > linkexternalworkbooks):
> >> > >
> >> > > RuntimeException
> >> > >  >> > root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#
> RuntimeException
> >> > >("Not
> >> > > Implemented - see bug #57184");
> >> > >
> >> > >
> >> > > The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184)
> refers
> >> > to bug 60219, which is supposed to be fixed in 3.15. However, it does
> >> not
> >> > seem that this bug really solves the issue I have.
> >> > >
> >> > > Does anyone know when external workbooks for XSSFWorkbooks will be
> >> > supported?
> >> > >
> >> > >
> >> > > Thank you a lot.
> >> > >
> >> > >
> >> > > best regards
> >> > >  B‹KK
> >> KKCB•
> >> > È [œÝXœØÜšX™K  K[XZ[ ˆ \Ù\‹][œÝXœØÜšX™P  ÚK˜\ XÚ K›Ü™ÃB‘›Üˆ Y  ] [Û˜[
> >> > ÛÛ[X[™ Ë  K[XZ[ ˆ \Ù\‹Z [ÚK˜\ XÚ K›Ü™ÃB
> >> >
> >> > -
> >> > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> >> > For additional commands, e-mail: user-h...@poi.apache.org
> >> >
> >> >
> >>
> >
> >
>

Re: Writing workbooks with linked workbooks using XSSFWorkbook

[Jörn Franke]

Ok, thank you. I will see, but I cannot promise anything.

> On 8 Jan 2017, at 21:23, Dominik Stadler  wrote:
> 
> Hi,
> 
> Unfortunately this is likely to stay unsupported until somebody comes up
> with the necessary changes. None of the few active devs is currently
> working on this as far as I see, though. Patches are always welcome if you
> managed to take a closer look yourself.
> 
> Dominik.
> 
>> On Tue, Jan 3, 2017 at 9:06 PM, Jörn Franke  wrote:
>> 
>> oh btw. you do not need a Hadoop installation to run the tests, they are
>> simple unit tests.
>> Simply clone https://github.com/ZuInnoTe/hadoopoffice.git
>> Remove all the @Ignore tags from
>> *
>> fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapred/
>> OfficeFormatHadoopExcelTest.java
>> * fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapreduce/
>> OfficeFormatHadoopExcelTest.java
>> 
>> Go to the fileformat. Run gradle clean build
>> 
>>> On Tue, Jan 3, 2017 at 9:03 PM, Jörn Franke  wrote:
>>> 
>>> Hi,
>>> 
>>> sorry I was a little bit late. I tried with 82 and still the same error:
>>> 
>>> java.lang.RuntimeException: Not Implemented - see bug #57184
>>> 
>>> 
>>> I do have a unit test, but it contains a lot of Hadoop stuff. Basically
>> this line fails with the message above:
>>> 
>>> currentWorkbook.linkExternalWorkbook(name,currentLinkedWorkbookParser.
>> getCurrentWorkbook());
>>> 
>>> 
>>> I can clearly see in the source code of XSSFWorkbook that
>> linkExternalWorkbook simply throws a runtime Exception.
>>> 
>>> The only thing that i want to do - and which works with the Excel2003
>> .xls format - is to add an external workbook to the current workbook, refer
>> in a formula to it, e.g. via [linkedwbfile.xlsx]Sheet1!B1. Even if do not
>> use linkExternalWorkbook, but only setupReferencedWorkbooks then i get a
>> null pointer exception when setting the formula referring to an external
>> workbook in the cell. Again this is only for XSSFWorkbook when
>> modifying/adding cells. HSSFWorkbook works fine.
>>> 
>>> I assume the formula evaluator of XSSFWorkbook simply does not
>> understand formulas with external workbook references.
>>> 
>>> 
>>> Let me know if I can do further analysis to solve the issue.
>>> 
>>> thank you a lot.
>>> 
>>> Best regards
>>> 
>>> 
>>> On Sat, Dec 31, 2016 at 6:00 PM, Dominik Stadler >> 
>>> wrote:
>>> 
 Hi,
 
 Bug 60219 was not fixed yet, but it is now.
 
 Can you re-try with a recent build from trunk or use the binaries from
 https://builds.apache.org/view/POI/job/POI-DSL-1.6/65/ when it
>> finishes.
 
 Thanks... Dominik.
 
 On Tue, Dec 27, 2016 at 5:21 PM, Jörn Franke 
 wrote:
 
> There is already a bug report, see my message.
> 
>> On 27 Dec 2016, at 17:15, Murphy, Mark 
> wrote:
>> 
>> If you create an issue in bugzilla with a unit test, It will be
>> easier
> to get that fixed.
>> 
>> -Original Message-
>> From: Jörn Franke [mailto:jornfra...@gmail.com]
>> Sent: Tuesday, December 27, 2016 9:53 AM
>> To: user@poi.apache.org
>> Subject: Writing workbooks with linked workbooks using XSSFWorkbook
>> 
>> Dear all,
>> 
>> I am currently writing an open source library for reading/writing
 office
> files on Hadoop/Spark/Hive/etc. The code is on Github and an official
> release in form of a library on maven central will follow soon.
>> The Excel files will be supported by the Apache POI library (3.15).
>> So far everything works quiet well, such as reading from linked
> workbooks (HSSF & XSSF), writing workbooks with linked workbooks
>> (HSSF).
> However, I have some issues with writing workbooks with linked
>> workbooks
> using XSSF. I receive the following exception (when calling
> linkexternalworkbooks):
>> 
>> RuntimeException
>>  root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#
>> RuntimeException
>> ("Not
>> Implemented - see bug #57184");
>> 
>> 
>> The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184)
>> refers
> to bug 60219, which is supposed to be fixed in 3.15. However, it does
 not
> seem that this bug really solves the issue I have.
>> 
>> Does anyone know when external workbooks for XSSFWorkbooks will be
> supported?
>> 
>> 
>> Thank you a lot.
>> 
>> 
>> best regards
>> B‹KK
 KKCB•
> È [œÝXœØÜšX™K  K[XZ[ ˆ \Ù\‹][œÝXœØÜšX™P  ÚK˜\ XÚ K›Ü™ÃB‘›Üˆ Y  ] [Û˜[
> ÛÛ[X[™ Ë  K[XZ[ ˆ \Ù\‹Z [ÚK˜\ XÚ K›Ü™ÃB
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> For additional commands, e-mail: user-h...@poi.apache.org
> 
> 
 
>>> 
>>> 
>>