Software adding unwanted code automatically

[tonyayres]

I have many formulae in a calc sheet. The first thing that happened (after several months of trouble-free use) was that LO inserted a sheet reference in front of every single cell reference, making it impossible to copy the formulae from one sheet into another. So I changed my formulae to more sohisticated versions using entries like this
=SUMPRODUCT(C6:V6,ISODD(COLUMN(C6:V6)))
which has far fewer cell refernces to be corrected if sheet names suddenly get inserted. I then gritted my teeth and began to convert all 150 sheets by hand. But then LO decided to change all the instances of ISODD to ISODD_ADD, which renders the formula inoperable.

It is the case that (a) I downloaded 5.2.6 just before this occurred, and it is also true that I have been saving the file in Excel format rather than in ods. I’m now saving it in ods, and am waiting for 5.2.7 to become available to see whether the version change problem has now gone away.

But it’s annoying. Is there any way of preventing it happening? I just wish software wouldn’t alter what I’ve typed without asking me first!

[mikekaganski]

You didn’t tell which version did you use previously (before installed 5.2.6).

There are four (closed long ago) issues in Bugzilla that mention ISODD_ADD, one of them being exactly your problem, however the reporter didn’t provide sufficient data, so the issue was closed invalid.

Wrt automatically added sheet references, could that be this issue? See also tdf#96591 and its last comment.

[tonyayres]

77367 seem to fit the bill. My previous version was 5.2.5. Providing the right data and filing a bug report will tax me to the limit of my humble abilities, but I’ll try to do something about it later. Many thanks to you and to w2016 for replying.

[w2016]

Could be a regression of bug 67572
Please file a bug report, otherwise chances are slim that it will be fixed soon on its own.

[tonyayres]

I don’t think it’s this one, which is about _ADD malfunctioning in its own right.