Defined Ranges Not Saved In Calc

asked 2015-09-01 01:43:50 +0200

chentiangemalc gravatar image

updated 2015-10-06 00:05:30 +0200

Alex Kemp gravatar image

Create Defined Range via Data -> Define Range, all disappear after saving and re-opening document. If I create a defined range in MIcrosoft Excel and open it in OpenOffice Calc, they appear fine.

Tried saving in ODS, Microsoft Office (XLSX) and OpenXML (XLSX) formats, all had same issue.

Calc Version: Build ID: 00m0(Build:5) Locale: en-US (en_US.UTF-8)

OS: chentiangemalc@lxle007:~$ uname -a Linux lxle007 3.13.0-63-generic #103-Ubuntu SMP Fri Aug 14 21:42:59 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

edit retag flag offensive close merge delete


I hit the same issue. Quite disappointed; I had more faith in LibreOffice than that.

jnm2 gravatar imagejnm2 ( 2016-04-10 05:21:52 +0200 )edit

I have recently installed LO v5.1.3.2 (x64) Calc with two different ranges in one worksheet and use those range names as part of a LOOKUP formula in cells in a different worksheet within the same workbook file. Works great when first created, however when I save and close the workbook file and later open it the formula changes to =NA() because it has lost the ranges. They are NOT displayed in the Data > Define Range > dialogue. Retyping formula - tooltip auto completes range but it does not work

bjaarmy gravatar imagebjaarmy ( 2016-05-24 11:09:58 +0200 )edit

I have the same issue. Anyone know if it has been solved yet?

tjdonahue gravatar imagetjdonahue ( 2017-04-11 06:41:44 +0200 )edit

I am having the same problem with Version: Hoping someone will see this thread and get the info to someone who can answer, and/or fix this.

rnebergall gravatar imagernebergall ( 2017-08-14 23:13:27 +0200 )edit

Wow, Three years later and even in version this is still unresolved. What is the point in having a feature like this which doesn't survive a save? Windows 7

argy gravatar imageargy ( 2019-03-21 12:59:46 +0200 )edit