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 >> > >> > >> > >
