Bug 63709

Summary: Provide support for generating DDE formulas in Workbooks
Product: POI Reporter: bernard <bht237>
Component: HSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: enhancement    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: Maven test case with LibreOffice source file in zip file.

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