| Summary: | BUG in simple Division !!! | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | stefan |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | rafael.palma.lima |
| Priority: | medium | ||
| Version: | 7.5.2.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
simple statistic chart
screenshow - weired results confusing Row "drag" calc |
||
|
Description
stefan
2023-04-14 20:42:15 UTC
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. |