Copy/paste formula in writer table?

asked 2019-05-11 03:36:53 +0200

appreciatethehelp gravatar image

updated 2019-05-24 04:21:50 +0200

Hey guys, just wondering how to copy/paste formulae in a writer table?

I would like the formula to "adapt" to the new location, as it would when copy/pasting "formula only" in Calc.

Thanks.

edit retag flag offensive close merge delete

Comments

Seems only possible this way:

  • copy formula from edit line without =
  • Hit F2 key in another cell ( = shows) and paste

Send a feature request / bug report.

Grantler gravatar imageGrantler ( 2019-05-11 08:31:40 +0200 )edit

Thanks for the input. I shall do as requested regarding the feature request/bug report.

appreciatethehelp gravatar imageappreciatethehelp ( 2019-05-12 16:49:31 +0200 )edit

This tip is helpful, however I would like the formula to adapt to the new location, as it does when copy/pasting "formula only" in Calc e.g. if I copy the formula A1 + B1 into the next row down I want it to adapt to B1 + C1. The instructions you gave copies the exact same formula referring to the same cells; A1 + B1 when copy/pasted remains A1 + B1.

appreciatethehelp gravatar imageappreciatethehelp ( 2019-05-24 04:19:46 +0200 )edit