https://bugs.documentfoundation.org/show_bug.cgi?id=151982
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] | |rg Resolution|--- |NOTABUG --- Comment #1 from m.a.riosv <[email protected]> --- I think you are misinterpreted how name ranges work. If you go to manage named ranges/expressions, staying in C3 or staying in D55. While you are in C3, the formula is: relativeTotalDays-COUNTIF(D3:WX3; ">0") -COUNTIF(D2:WX2; ">0") While in G55, the formula is: relativeTotalDays-COUNTIF(H55:XB55; ">0") -COUNTIF(H54:XB54; ">0") In the COUNTIF you have relative addresses, please take a look on https://wiki.documentfoundation.org/Macros/Calc/ba020 -- You are receiving this mail because: You are the assignee for the bug.
