Bug 63709 - Failure to generate DDE formula in HSSFWorkbook
Summary: Failure to generate DDE formula in HSSFWorkbook
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-30 11:44 UTC by bernard
Modified: 2019-08-30 11:44 UTC (History)
0 users



Attachments
Maven test case with LibreOffice source file in zip file. (8.79 KB, application/zip)
2019-08-30 11:44 UTC, bernard
Details

Note You need to log in before you can comment on or make changes to this bug.
Description bernard 2019-08-30 11:44:04 UTC
Created attachment 36747 [details]
Maven test case with LibreOffice source file in zip file.

It appears that POI cannot generate a DDE formula in a cell.

Please refer the attached test case. For convenience, LibreOffice (soffice) is used as a DDE server.

I am getting =(#NAME?,"soffice", ... in the spreadsheet, so the DDE( ... function is not coded as expected for some reason.


The test case generates the formula. I am testing the generated spreadsheet with LibreOffice Version: 6.2.5.2 (x64).

This appears to be significant because LibreOffice supports the DDE function as much as Excel. DDE is somewhat outdated but still widely supported.

For me, the generation of the function by POI instead of manually entering it into a spreadsheet is a significant feature. That is because there is an issue with coding a DDE function whose parameter values are taken from spreadsheet cells not hard-coded:

https://bugs.documentfoundation.org/show_bug.cgi?id=127210