• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 502
  • Last Modified:

trouble with variable names in libreoffice calc

I cannot give my variables sensible names because I don't understand what is confusing LO.
EE-investments-2014-Jan-19.ods
0
dwcronin
Asked:
dwcronin
  • 2
  • 2
1 Solution
 
ltlbearand3Commented:
I think this is related to your other question here.  If these are the same, here is what I think is going on.  It looks like you have database ranges and sheet ranges mixed up together.  Notice here in database ranges that you have several ranges (from the menu Data >> Define Range)
Data Ranges
Now if you look at your named ranges, you will see another list:
Selecting Named RangesNotice in this list that some items have the #REF! error:
Your Named RangesThe named ranges are what you want to be set correctly for the way you are using them in formulas.  Update those values here and your sheet will work better.
EE-investments-2014-Jan-19.ods
0
 
dwcroninAuthor Commented:
I don't know anything about databases so it was a mistake they are designated that way.
0
 
ltlbearand3Commented:
Did the change to named ranges and/or the uploaded calc sheet help or work for you?
0
 
dwcroninAuthor Commented:
thank you
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now