Delete a named range or at least set its proper range

[athegn]

I have found old questions on named ranges saying that I can delete a range by using Insert > Named Range or Expressions then using the delete button. On my Libre Office version 6.0.7.3 there is no delete button. All I can do is paste using that facility.

How do I delete a range.

I am having trouble with a named range. If I go to the top left of a sheet, Manage names dialog box, selects the whole column for a named range; the range shown in Named Range or Expressions shows the range as $0:$0 yes full column. However if I select from Data > Select Range I get O1:O108 which is what I want. My problem is that on another sheet a formula looks for this named rangeand gives results based on $O:$O.

I have tried deleting the range Data > Define Range (the only delete option I can find) but to no avail.

Any advice please?

[Hrbrgr]

Select Data>Set Range from the menu. In the “Set Database Area” dialog box, mark the name of the area to be deleted and click on “Delete”.

[athegn]

My version of Libre Office does not have Data>Set Range. I have Data > Define Range but there is not “Set Database Area” dialog box there.

I have used the “Define range” to delete the named range. Yes it is deleted from Data but the range still exists in Managed Names and shows in “Named Range or Expressions” How do I delete the range in these dialogs?

[athegn]

OK may have answer to delete range. In Menu > Sheet > Named Range or Expressions I can delete a named range. There are TWO places where Named Range or Expressions appears! Data and Sheet.

Now delete Range Name in Sheet then recreated in Data. Now formula works.

[athegn]

My version of Libre Office (6.0.7.3) does not have Data > Set Range . What version of Libre Office does have that facility?

[Hrbrgr]

With me Windows 10, Version 1809, 64-Bit | LibreOffice, Version: 6.2.0.3 (x64). Sorry, it is a translation from a German UI. It should be similar.

[athegn]

If I want to update Libre Office I am offered 6.1.5 not the later 6.2.0.3 you have.How I will update to 6.1.5 to see if that makes a difference. I see I can download 6.2.0.3 but for power users only?? Will try BTW mine is a 32bit setup.

[athegn]

Now updated to 6.2.0.3 but still no Data > Set Range

[Tigus]

I had the same issue (using Clac 7.3.7.2 on Ubuntu), when the range still appeared after deleting it from the Sheet > Named Ranges and Expressions > Manage. I realised I was confusing two sets of ranges, which may or not be your case too, i.e. a Named Range vs a Database Range. I had in fact created two ranges, one of each type, with the same name, which certainly fuelled my confusion.

The Named Range is managed through the Sheet > Named Ranges and Expressions menu, while the Database Range is managed through the Data > Define Range menu. To delete the latter, I used Data > Define Range > selected the range and the Delete button became clickable.

Good luck.