Bug 86901 - Libreoffice Calc-Colored boxes in change furmula
Summary: Libreoffice Calc-Colored boxes in change furmula
Status: RESOLVED DUPLICATE of bug 78221
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2014-12-01 11:25 UTC by bfede
Modified: 2014-12-06 21:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description bfede 2014-12-01 11:25:07 UTC
I apologize for English is to be automatic translator. What I want to point out is not a problem, but a need for change in order to reduce errors in the use of the program. With the new version was introtta displaying contours of the cells in the formulas of the same color if the reference to the same cell is repeated several times. But if I copy the cell with the formula, and then I have to change the references to other cells by moving the colored outline of a cell with multiple references) this does not make me more to see, as was the case before an outline of a different color, but does not give me anything , so once edited the first reference, I have to re-enter the cell and riesegure the operation, doing this as many times as the references to the same cell that must be moved. This thing before it was directly without going out since moved the first reference was seen in the second and the third ventualmente and we went to move sequentially, without oqgni time leave and return. I try to explain with an example megliio. Suppose you have a formula in cell A1 in which an addendum refers three times to cell B5, suppose that should copy this formula in B1 and this time the adder that did rifierimento to B5 must reference B6, I have to manually change the formula going to move the square (eg. blue).

In version 4.2 I had to expiate the previous three squares (ex. Blue, green, red) so once entarto formula was moving in the three square from cell to cell B5 B6 without exiting. Now with the veriosne 4.3 I have a single square (eg. Blue) and to move the three reference I entre once move, and then exit the formula, categorized according to enter a time and move, and then a third time unscire enter, move, and then come out. Will understand that for long and complicated formulas with multiple references, and present in various points of the formula facilitates the operation errors as well as being long. It would be appropriate to leave the same color but immediately update the color of the square moved or otherwise leave visible squares of the same color stacked in the cell. Referring to the example above, I move the first blue square, but it remains under another always blue (or other color) and so to move all the blue ones of the cell B5, without having to continually get out of shape change
Comment 1 Jean-Baptiste Faure 2014-12-06 21:10:11 UTC
If I understand correctly, this is a enhancement request for LibreOffice Calc.

Best regards. JBF
Comment 2 GerardF 2014-12-06 21:31:20 UTC
IMHO this is a bug, not an enhancement.
Anyway this is already reported.

*** This bug has been marked as a duplicate of bug 78221 ***