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 <jornfra...@gmail.com> 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 <jornfra...@gmail.com> 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 <dominik.stad...@gmx.at > > > > 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 <jornfra...@gmail.com> > >> wrote: > >> > >> > There is already a bug report, see my message. > >> > > >> > > On 27 Dec 2016, at 17:15, Murphy, Mark <murphym...@metalexmfg.com> > >> > 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 > >> > > <http://grepcode.com/file/repository.grepcode.com/java/ > >> > 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‹KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK > >> KKKKKKKKKKCB• > >> > È [œÝ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 > >> > > >> > > >> > > > > >
