Summary: | Paste Special should have an option to paste raw formulas | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Stéphane Guillou (stragu) <stephane.guillou> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | barta, cno, dent.ace, erack, heiko.tietze, miguelangelrv, philipz85 |
Priority: | medium | ||
Version: | 4.1.0.4 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=45385 | ||
Whiteboard: | BSA | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 107977, 108479 |
Description
Stéphane Guillou (stragu)
2014-04-29 12:14:36 UTC
Hi chtfn, thanks for reporting. I think you can get it easily, instead of copy, cut and paste in the actual position and in the new one, both will have the same formulas without change in the references. Hi m.a.riosv Thanks for the answer. This solution resolves the second case, but not the first one, when the user does not want to delete the source. Why not?, cut and paste in the source range before moving to any other range to paste. It's no perfect but it's simple. I just tested your workaround and it does not work. The second paste does shift the coordinates. Cheers I have just verify that it works for the first past, after that it works like copy, what works fine pasting then again in the source range. Remember there is the option to copy one/several sheets at once in the some or in a new file. I understand your workaround, but it is extremely unintuitive (cut, paste in target, paste in source). About copying a sheet from one document to another, a good thing is that it does not link to the source document's cells, but it still shifts the spreadsheet references. The idea is that, whith that extra option, the formula text does not change at all when the sheets/cells are copied. enhancement request UX Team -- please take a look at this enhancement. Thanks! Really sorry if this does not relate to UX; I might have misunderstood the team's role. I wanted to mention that this enhancement would resolve this kind of support question: https://ask.libreoffice.org/en/question/8925/how-can-i-copy-paste-calc-formulas-with-absolute-references/ 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. No further input so I'll remove needsUX flag. IMHO, the de/formularizer would be an interesting enhancement and a cool GSoC project. To clarify the cut/paste workaround, the way to get a copy between documents (or locations within a single document) while retaining the existing copy is to: 1. Select the cells. 2. Cut. 3. Undo. 4. Move to new location. 5. Paste. Unfortunately, this is a non-obvious hack (although one I have been using for years), and still only works for a single paste. Subsequent pastes are treated as copies, as noted in previous comments. A real solution to this would be incredibly helpful for the use cases proposed 5 years ago, which I encounter regularly in my work. Eike taught me lately the Sheet > Cycle Cell Reference Type (F4) command that iterates over reference types (=$A$1, =A$1, =$A1, =A1). So I guess he recommends to close this issue as WF (too many functions; keep it simple) resp. WFM (change the reference type before copying). Erm.. cycle reference types isn't a solution to this specific request though if there are more than one formula cells involved or a formula has a mix of absolute/relative references that is to be preserved. |