problem with LO calc 4.4.0.3

[JohnV1]

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]

JOHN

[Regina]

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

[rautamiekka]

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