Description: Dear Libre Office Team, I found a strange behavior in when calculating a simple statistic, with a division. When filling a Calc Chart with values and try to use a division to get results like / power per time -> and be dragging down on a valid formula, every second value is calculates wrong. -> dooing this cell-by-cell works, but is not very user frendly for a bigger number of values. Kind Regards, S.Klerx Actual Results: With manual cell-by-cell it works, but it is not userfrendly ! Expected Results: Dragging down on a valid formula shows the correct values. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes
Can you share a file with a more concrete example of what the problem is? With your description I cannot reproduce the problem.
Created attachment 186674 [details] simple statistic chart
As I could not reply to the request I try to fill this form (unconveinient). Reply was: Sure--- try this file an drag down colum H (h3 down to h17) - you should immedialtly see the problem.
Created attachment 186675 [details] screenshow - weired results
The problem here is simple. You're always dividing H1 by the values in column C, but the value of H1 is fixed. When you drag down the formula, H1 gets updated downwards (H2, H3, H4...) as well as column C (C3, C4, C5...). But in the case of column H, since you want to keep it fixed in H1, you need to lock it. For that, replace H1 in the formula by $H$1, which locks the column/row. Closing this as NAB.
OK got some "hint"- in Row H -> the usage of "$" solves the issue in some way: =$H$1/[scaling]. But the behavior is strange, as the tool does not recognize the reference point and that every 2nd line is "0" is also irretating.
Dear Support Team, Thank you for the quick response. I can live with conclusion of using "$" but I must admit, that the MS-(exivalanet/evil/as-you-like-to-call-it) is somewhat more intuitive. > I will still keep with LibreOffice (thank you so mutch), but some people might be confused like me in the first try. PLS keep up the good work. Kind Regards S.Klerx
Yust to make my confusion clear- pls see attaches screenshot
Created attachment 186677 [details] confusing Row "drag" calc
(In reply to stefan from comment #7) > Dear Support Team, > Thank you for the quick response. I can live with conclusion of using "$" > but I must admit, that the MS-(exivalanet/evil/as-you-like-to-call-it) is > somewhat more intuitive. > I will still keep with LibreOffice (thank you so > mutch), but some people might be confused like me in the first try. You will find that MS Excel behaves the same: dragging that cell down will update relative references, resulting in the same values. Closing as "not a bug". Thank you both!
See: https://help.libreoffice.org/latest/en-US/text/scalc/guide/relativ_absolut_ref.html Although I think this should not be done as a general rule, I am posting the following link in order to hint others that they should not report "bugs" before some minimal web search. https://support.microsoft.com/en-us/office/switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9 Please next time perform a web search, or go to https://ask.libreoffice.org This site is for bug reports. Thank you.