Named ranges problem in Calc [closed]

asked 2016-05-31 05:33:24 +0200

Jobo gravatar image

updated 2020-09-06 01:38:54 +0200

Alex Kemp gravatar image


There appears to be a minor bug with named ranges in a new formula.

I have named a cell which I have named "talking". If I click on another cell and enter "=talking" and hit enter, it does nothing, like it is refusing to accept the contents of the cell. This also occurs for other cells, with different names.

However I can make it accept by any of the following methods:

  • hitting enter twice
  • clicking on the button which has an arrow going down and then left, near the cell contents field
  • entering "=talking+0" and then removing the "+0"
  • copying and pasting from another field which has the same formula in it.

Is this a bug or just unusual expected behaviour?

(BTW I am using version on Linux Mint).


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-06 01:39:07.413772


How do you define the range like an absolute or relative reference?

m.a.riosv gravatar imagem.a.riosv ( 2016-05-31 09:50:04 +0200 )edit