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/03/04 10:28:40 UTC
[Bug 63228] New: Method copyCellFrom
(org.apache.poi.xssf.usermodel.XSSFCell) doesn't update formula reference
https://bz.apache.org/bugzilla/show_bug.cgi?id=63228
Bug ID: 63228
Summary: Method copyCellFrom
(org.apache.poi.xssf.usermodel.XSSFCell) doesn't
update formula reference
Product: POI
Version: 3.17-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: nick@fina2.net
Target Milestone: ---
When i copy formula with reference to other cell, the new formula has old
reference.
I am using org.apache.poi.xssf.usermodel.XSSFCell copyCellFrom method, with
copyCellFormula=true.
Example:
B5 = B2+1 after copy to C5 = B2+1 instead of C5 = C2+1
--
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 63228] Method copyCellFrom
(org.apache.poi.xssf.usermodel.XSSFCell) doesn't update formula reference
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63228
FINA <ka...@fina2.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
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 63228] Method copyCellFrom
(org.apache.poi.xssf.usermodel.XSSFCell) doesn't update formula reference
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63228
FINA <ka...@fina2.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P2 |P3
--
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 63228] Method copyCellFrom
(org.apache.poi.xssf.usermodel.XSSFCell) doesn't update formula reference
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63228
FINA <ka...@fina2.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
Status|NEW |NEEDINFO
--- Comment #1 from FINA <ka...@fina2.net> ---
There is a lot of cases when you may need such feature when for instance you
are summing 3 items on column B ( i.e B1=B10+B11+B12) and after copying cell
from B1 to C1 you expect formula C1=C10+C11+C12, but instead of that you see
same formula as it was in B1 ( C1= B10+B11+B12 which is wrong).
Any idea how and/or when to correct it?
Or maybe someone knows the workaround ?
Thank you in advance for any response or advise.
--
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 63228] Method copyCellFrom
(org.apache.poi.xssf.usermodel.XSSFCell) doesn't update formula reference
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63228
FINA <ka...@fina2.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kakhaberi@fina2.net
--
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 63228] Method copyCellFrom
(org.apache.poi.xssf.usermodel.XSSFCell) doesn't update formula reference
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63228
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |INFORMATIONPROVIDED
Status|NEW |RESOLVED
--- Comment #2 from PJ Fanning <fa...@yahoo.com> ---
copyCellFrom javadoc says that it does not shift references in formulas - the
XSSFRow copyRowFrom does update formulas but the cell copy doesn't
/**
* Copy cell value, formula and style, from srcCell per cell copy policy
* If srcCell is null, clears the cell value and cell style per cell copy
policy
*
* This does not shift references in formulas. Use {@link
org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter} to shift references in
formulas.
*
* @param srcCell The cell to take value, formula and style from
* @param policy The policy for copying the information, see {@link
CellCopyPolicy}
* @throws IllegalArgumentException if copy cell style and srcCell is from
a different workbook
* @see CellUtil#copyCell(Cell, Cell, CellCopyPolicy, CellCopyContext)
*/
--
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