[Libreoffice-ux-advise] [Bug 78074] Paste Special should have an option to paste raw formulas

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=78074

--- Comment #9 from Heiko Tietze <tietze.heiko at gmail.com> ---
Rather than introducing another paste special option I would think about the
mentioned "deformularizer". The issue is also relevant in other cases:

Given A1 contains a value and A2 "=A1" the copy/paste operation to A3 returns
"=A2", which is wanted in most cases but sometimes you need the exact same cell
done by "=$A$2". 

The (de)formularizer could toggle fix row/column on/off; in case of the
table/sheet reference it would set it to the current sheet when switching on.

-- 
You are receiving this mail because:
You are on the CC list for the bug.