Ask Your Question
0

cell reference always include sheet name

asked 2016-06-26 04:31:30 +0200

AndresSolar gravatar image

Hi,

I have a problem with a calc file. for some reason, calc always include the sheet name to references on the same sheet. Is this due to a preference setting?

Thanks in advance

edit retag flag offensive close merge delete

Comments

Please report your LibreOffice version and your operating system.

m.a.riosv gravatar imagem.a.riosv ( 2016-06-26 12:42:42 +0200 )edit

In the other forum you also mentioned a public grid blackout preceeding the observations. This is relevant information you should not abandon here.

Lupp gravatar imageLupp ( 2016-06-26 22:16:46 +0200 )edit

No. It applies to both installations (V. 5.1.3.2 on OS X El Capitan). On was not affected by the blackout since installed on a MacBook Pro 15

AndresSolar gravatar imageAndresSolar ( 2016-06-27 03:16:48 +0200 )edit

I don't exactly know why, but after restoring the old user profile and cleaning up (search&replace) all formulas, the problem seems banned for know.

AndresSolar gravatar imageAndresSolar ( 2016-06-27 04:45:04 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-06-26 22:12:57 +0200

Lupp gravatar image
edit flag offensive delete link more

Comments

dead link 20170315

milan gravatar imagemilan ( 2017-03-15 17:27:59 +0200 )edit

The much better structured forum the linked contribution was posted in was closed down (See this announcement). Part of its content was saved (thanks to @Charlie.it), but other parts obviously were lost. I have no draft of the post under discussion and I do not remember its content.
Sorry.

Lupp gravatar imageLupp ( 2017-03-15 19:11:33 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2016-06-26 04:31:30 +0200

Seen: 214 times

Last updated: Jun 26 '16