https://bugs.documentfoundation.org/show_bug.cgi?id=115173
Bug ID: 115173
Summary: EDITING: Drag to fill (Replicate) not always
accurately replicating/updating cell references
Product: LibreOffice
Version: 5.4.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
First I must apologise, I have no idea how to phrase the summary nor how to
search for any existing reports which may be pertinent. I am experiencing
situations where dragging a cell to replicate the contents doesn't always
correctly assign the functionality. I have experienced two manifestations. One
where some target cells failed to calculate when preceding and following cell
copies perform as expected - the formula replicates ok but the result is null.
I have copied, pasted, inserted and removed cells to no avail and ultimately
simply retyped the formula which then resolved the issue. another successful
ruse was to copy and paste the formula into a text document, clear the source
and then copy and paste it back from the text document. Potentially indicates
that when it thinks it is "importing" something it works. In one case for this
example, I was replicating a large number of single column formulae over a
substantial length and so paused to verify how far I had "travelled". There
were multiple cells affected and it was necessary to search for the gaps to
identify the failures. I Couldn't swear that it functioned perfectly if I just
typed the target end cell reference and pasted the contents into the entire
selection. I have had some success in resolving the issue by saving the sheet
and then exiting and re-loading, at which point the glitch appears resolved.
The second manifestation is where a single formula is copied to just a small
number of cells in the same column and despite the fact that the few adjacent
cells referenced as sources for the calculation contain vastly different values
the calculated results are identical. Again, copy, paste, insert, delete
doesn't appear to "clear" the error condition and I must retype and repopulate
the cells for it to function. It's almost as if the data/references become
"locked" in the internal memory and despite the cell formulae appearing
"normal" the function is not performed on an array and the first(or last,
middle, random) elements of the array are then replicated to all the other
affected cells. 35 cells each with a different adjacent source and the
identical result. It's not the formula being "copied" it's the result of one
calculation. It's impossible to provide you with a malfunctioning sheet
because it seems to clear when the sheet is closed.
Steps to Reproduce:
1. Indefinable, I'm hoping somebody reading the summary will understand and
have half an idea where to start
2.
3.
Actual Results:
Failed to correctly copy formulae and/or display the results
Expected Results:
repeated formulae with verifiable results
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
[Information edited from LibreOffice]
Version: 5.4.4.2 (x64)
Build ID: 2524958677847fb3bb44820e40380acbe820f960
CPU threads: 4; OS: Windows 6.19; UI render: default;
Locale: en-GB (en_GB); Calc: group
Locale: en-GB
Module: Calc
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101
Firefox/57.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
