Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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