problem with LO calc 4.4.0.3

asked 2015-12-02 11:46:51 +0100

JohnV gravatar image

updated 2015-12-02 18:46:58 +0100

Alex Kemp gravatar image

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

edit retag flag offensive close merge delete

Comments

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

Regina gravatar imageRegina ( 2015-12-02 20:08:15 +0100 )edit

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

rautamiekka gravatar imagerautamiekka ( 2015-12-02 20:15:05 +0100 )edit