https://bugs.documentfoundation.org/show_bug.cgi?id=99956
Howard Brown <howar...@earthlink.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #10 from Howard Brown <howar...@earthlink.net> ---
> What you comment as fixed references are denominated as absolute reference
> and not fixed are relative references.
Thank you, I wasn't sure what to call the types of cell references that I was
using, so I used a descriptive term in quotes to try to make the actions as
clear as I could. By the way, when you use a $ before the column, but not
before the row, is that still a relative reference or is it called something
else?
Anyway, as I understand it a relative reference range like I'm using, i.e.,
$B$24:$B33 should remain unchanged unless I insert new rows between rows 24 and
33, but this isn't happening, as demonstrated in the video I uploaded.
I misunderstood what was causing the Err:522 errors when I first reported it,
thinking that the problem had to do with the named range begins used in the
numerator of the percent completion formula and the spreadsheet conversion to
the excel .xls format, but as I worked with the problem further, I found that
other formulas were 'outputting' Err:522 messages, and that the spreadsheet
could be saved as native .ods files or not even safed.
> Why do you have changed the status?
My mistake, I thought I was supposed to do that. Mainly, I was trying to
respond to the assertion that the problem I was reporting was cause by my
creating the named range with circular references, but that's just a symptom of
the real problem, which is that Calc was incorrectly and randomly changing the
named ranges I created using relative cell references, and sometimes the
results are circular references.
While I didn't at first know the actual cause of the problem and I didn't use
the right terms in my description of the problem, the issue is has been the
same all along. I'm not reporting new problems, only a more complete
description of what is happening and I think it is a pretty big issue for Calc
when you can't trust that a named range won't be corrupted, so I reported it.
Thank you,
Howard Brown
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
