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

Hi,

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 5.0.3.2 on Linux Mint).

Thanks

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

Comments

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