Summary: | Can not copy "value only" from calculated range to other range (it show all value in a cell) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | btx_xx |
Component: | Writer | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTABUG | ||
Severity: | normal | CC: | philipz85, stgohi-lobugs |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 103100 | ||
Attachments: | example table and details of problem |
Description
btx_xx
2015-11-02 07:36:51 UTC
I am not sure if I understand your issue right. But from my point of view this is no bug. If you select a cell with a formula and copy it to another cell then the formula is also copied (see https://help.libreoffice.org/Calc/Copying_Formulas). If you want to copy only the value itself, but not the formula (because the copied formula will calculate a new value) then you need to choose EDIT -> PASTE SPECIAL and click OK (pay attention FORMULAE is not checked). In addition, you could insert a copied value with a right mouse click and then go in the context menu to PASTE ONLY -> NUMBER. Does this explanation already solve your issue? Created attachment 120472 [details]
example table and details of problem
explain the details of problem in the example table
(In reply to A (Andy) from comment #1) > I am not sure if I understand your issue right. But from my point of view > this is no bug. > > If you select a cell with a formula and copy it to another cell then the > formula is also copied (see > https://help.libreoffice.org/Calc/Copying_Formulas). > > If you want to copy only the value itself, but not the formula (because the > copied formula will calculate a new value) then you need to choose EDIT -> > PASTE SPECIAL and click OK (pay attention FORMULAE is not checked). In > addition, you could insert a copied value with a right mouse click and then > go in the context menu to PASTE ONLY -> NUMBER. > > Does this explanation already solve your issue? Please look in my additional sample above to more information. Thank you. anyone can help me? Hi btx_xx,
Thank you for reporting the bug. I tested attachment 120472 [details] and your expectation that pasting into column D would retain the same formula as when in it was copied from column C is incorrect and not how Calc works either. Writer's tables function differently to Calc's cells, so this isnt a bug.
|