<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Paste Special should have an option to paste raw formulas" href="https://bugs.documentfoundation.org/show_bug.cgi?id=78074#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Paste Special should have an option to paste raw formulas" href="https://bugs.documentfoundation.org/show_bug.cgi?id=78074">bug 78074</a> from <a class="email" href="mailto:tietze.heiko@gmail.com" title="Heiko Tietze <tietze.heiko@gmail.com>"> Heiko Tietze</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>