https://bz.apache.org/bugzilla/show_bug.cgi?id=61840
--- Comment #4 from Javen O'Neal <[email protected]> --- (In reply to Luca from comment #2) > setCellFormula(anotherCell.getCellFormula()); formula is treated as a mere > string and references are not updated. setCellFormula intentionally does not shift the formula that is pasted into it. It sets the cell formula as is. Perhaps what you're looking for is a function that copies a cell value from another cell, and if the source cell contains a formula, to shift that formula. Currently POI only contains methods to copy entire rows (Sheet.copyRows). Adding capability for copying just a cell is a good idea, and should be captured on a new bug. -- 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]
