How do I remove sheet names from the formula in a cell?

English
,
#1

If the sheet name is in the cell, when I left click in the input line, the cells referenced in the formula are not always indicated by colored boxes.

without colored boxes
without colored boxes814×358 227 KB
with colored boxes
with colored boxes807×348 169 KB

#2

Is there any reason why you can’t simply edit the formula in the formula bar?

#3

The bug is the absence of highlighting if the sheet name is in quotes (contains spaces).

#4

Read https://wiki.documentfoundation.org/Ask/Getting_Started before you post.

#5

To fix the problem, rename sheets to use underscores (_) or Camel case instead of spaces.

#6

Also can Search & Replace 'funny one'. for nothing.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.