Ok, thank you. I will see, but I cannot promise anything. > On 8 Jan 2017, at 21:23, Dominik Stadler <dominik.stad...@gmx.at> 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 <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 >>>>> >>>>> >>>> >>> >>> >>
--------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
