problem with LO calc

I always type formulas into formula bar - but trouble with LO adding sheet name to every cell reference for reference that are on the same sheet! I am elderly and this makes it very hard to understand what the formula is meant to do.
The structure of workbook is :

  1. 20 worksheets
  2. 6 worksheets hidden which contain defined range names used throughout workbook [avoids absolute reference issues]
  3. solid inter-link sheet structure - based on defined range names.

But what was straight forward has been complicated by sheet names being inserted into ALL my typed formulas. I have already gone through task of manually removing these using FIND & REPLACE [not the easiest task]. But they have come back again!

Any way to 1. Remove them 2. prevent them from coming back!
Your help would be greatly appreciated

[I can email workbook if that will help]


Which file format do you use? ods, xls, xlsx, or …? Do you see the same problem with a new document?

You should upgrade, is way older than any stable version available.