https://bz.apache.org/bugzilla/show_bug.cgi?id=63709
Bug ID: 63709
Summary: Failure to generate DDE formula in HSSFWorkbook
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 36747
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36747&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
