https://bugs.documentfoundation.org/show_bug.cgi?id=144294
--- Comment #12 from Colin <[email protected]> --- (In reply to Colin from comment #10) > (In reply to Mike Kaganski from comment #7) > > I open the two completely different attachments. The "Version 6 Save" has > > plain "4" in Stats.M4, while "Version 7 Save" has "5" there. That cell is > > used in the formula in 'Version 7 Save'.AllHits.E1; but 'Version 6 > > Save'.AllHits.E1 refers to Stats.N4, which is a formula returning a string > > "04". The AllHits.E1 is used in AllHits.E6... how could one compare? > > They're a three week old version that worked fine with "formulae follow me" > applied and a today version that fails and the only differnce I can identify > is that I originally forgot to set "follow me" with v.7 and then realised my > omission and subsequently set it . > If you look, even though the underlying data is different, the test is still > to discover whether the "zero padded number" in the absolute source cell > appears anywhere in the relative string of the comparison cell. > It Doesn't Sorry Mike, I just fully absorbed what you said. The zero-padding that has existed since 2013 has disappeared from the sheet. Hence say a "9" is also being returned within a "29". Will you make it NOTABUG or should I? -- You are receiving this mail because: You are the assignee for the bug.
