https://bugs.documentfoundation.org/show_bug.cgi?id=153506
bwilder...@yahoo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|NOTABUG |---
Status|RESOLVED |REOPENED
--- Comment #7 from bwilder...@yahoo.com ---
Sorry, but I don't think we are on the same page on this one. I fully
understand how conditional formatting works... and the yyyy sheet correctly
reflects the conditional formats as they need to be. That is, for row 18 the
cell value for each month is compared to the $budget.$B23, and for row 19 the
cell value for each month is compared to $budget.$B24. In short, there are two
distinct rows cells requiring comparison against two distinct budget cells.
In short, as a retired computer programmer myself with 40+ years of experience,
I believe this remains a bug. At a minimum, the move or copy sheet function
should not modify the column and row numbers used in cell references regardless
of whether these references are defined within the conditional formats or
simply used in the cell value calculations, and regardless of whether or not
the absolute or relative column and row references are used. The only change
that I would expect during a move or copy of a sheet is the relative sheet name
should be changed. That is, any sheet names references yyyy should be updated
to the 2023. This seems to be working as expected.
The reason that absolute row addresses can not be used is because the budget
sheet can have additional rows added over time, and this fact requires the
automatic update of all row reference is other sheets in order to prevent
incorrect cell values from being used. Note, for this particular budget
spreadsheet definition, new expenses (i.e. - rows) can be added over time to
the budget sheet but no new columns are allowed. Therefore, the other sheets
need to use relative row numbers in order to be kept in proper sync with
existing values when new rows (i.e. - expenses) are added to the budget.
I have used this same kind of conditional formatting in Microsoft Excel and it
has worked as I described above.
The simplest thing to do is whenever a sheet is copied then make an exact copy
the entire sheet contents including conditional formatting, and only update the
relative original sheet name references to use the new sheet name. The extra
step that is apparently being done to reduce the number of distinct ranges in
the conditional formats is very complex logic and prone to difficulties such as
described in this bug report. I recommend the keep it simple approach, and
just keep the conditional formats in the new sheet as they were in the original
sheet-- with the one exception of updating the relative sheet name references
as described above. Note, the bug is in the merge of rows during the copy
sheet function. The original sheet works just fine with the existing 2 lines
using relative row references. New sheets created as copies from the original
should work the same as the original--- but in this case they do not because of
the bug.
Hope this helps to get on the same page.
--
You are receiving this mail because:
You are the assignee for the bug.
