You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2019/08/30 11:44:04 UTC
[Bug 63709] New: Failure to generate DDE formula in HSSFWorkbook
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: dev@poi.apache.org
Reporter: bht237@gmail.com
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63709] Provide support for generating DDE formulas in Workbooks
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63709
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Failure to generate DDE |Provide support for
|formula in HSSFWorkbook |generating DDE formulas in
| |Workbooks
Severity|normal |enhancement
OS| |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org