<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_CLOSED bz_closed" title="CLOSED WONTFIX - Relative Cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=127633#c16">Comment # 16</a> on <a class="bz_bug_link bz_status_CLOSED bz_closed" title="CLOSED WONTFIX - Relative Cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=127633">bug 127633</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>(In reply to Rick C. Hodgin from <a href="show_bug.cgi?id=127633#c14">comment #14</a>) > 3) A post-processing step on UI presentation, where the actual formula for > the cell is processed to reference !!native cells (like !!A1 for the real > A1), and to take anything in the visible range and PRESENT IT as a relative > name. You mean you want to re-parse the formula string generated from tokens and present it differently? Sounds error-prone to me. > 4) A pre-processing step on the syntax parser for formula input, that does > the reverse of 3), making the relative values be real values. Same here, pre-processing a string to produce another string is an error-prone overhead. > 5) A new flag in the saved ods file indicating if the sheet's in relative > view or not. I'd not save/load that to/from file. It would be utterly confusing to a user loading such document if not familiar with the feature/syntax. > This could be implemented as a visible-at-the-UI-level change only, with > post- and pre- processing code injected in 3) and 4) as indicated. You'd have to re-implement a lexicalizer just to handle the cell reference bits. But maybe I'm missing something in your idea. Anyway, if that's the approach to go then probably post-processing should take place in sc/source/ui/view/tabvwsha.cxx ScTabViewShell::UpdateInputHandler() line 669 where rCell.mpFormula->GetFormula(aString) is called. The pre-processing probably in sc/source/ui/view/viewfunc.cxx ScViewFunc::EnterData() that detects a formula entry and ScViewFunc::EnterMatrix().</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>