Ask Your Question
0

Calc: Formulas suddenly showing Sheet Name

asked 2016-02-28 06:36:19 +0200

mark gravatar image

updated 2016-03-07 21:39:35 +0200

Alex Kemp gravatar image

I have a Calc work book which was last opened a few weeks ago. This time, I found that all the formulas with relative references show the sheet name before the reference. Eg Stuff.A3

When I create a new formula, this doesn’t happen. I can also remove the sheet names either by direct editing or by Find & Replace.

Is this a known issue?

Using Mac OSX 10.11.3 and LO 5.0.2.2 (which I notice is slightly dated).

edit retag flag offensive close merge delete

Comments

There is bug report with needinfo status: https://bugs.documentfoundation.org/s...

m.a.riosv gravatar imagem.a.riosv ( 2016-02-28 19:51:08 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-02-28 14:13:11 +0200

Lupp gravatar image

My main suspicion: A corrupted user profile. Cf. this wiki page.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-02-28 06:36:19 +0200

Seen: 471 times

Last updated: Feb 28 '16