Ask Your Question

software adding unwanted code automatically

asked 2017-03-24 01:38:52 +0200

tonyayres gravatar image

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!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-03-24 07:59:36 +0200

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.

edit flag offensive delete link more


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.

tonyayres gravatar imagetonyayres ( 2017-03-25 02:58:02 +0200 )edit

answered 2017-03-24 08:14:44 +0200

w2016 gravatar image

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.

edit flag offensive delete link more


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

tonyayres gravatar imagetonyayres ( 2017-03-25 02:54:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-24 01:38:52 +0200

Seen: 48 times

Last updated: Mar 24 '17