Bug 114807 - Adding a variable within Calc.
Summary: Adding a variable within Calc.
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.4.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-02 16:44 UTC by Mark Mclean
Modified: 2018-01-02 23:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Mclean 2018-01-02 16:44:26 UTC 
Description:
I have used visual basic in M. S. excel. It allowed for variables to be created. Would be very helpful if it is possible to have them in a spread sheet. 

Steps to Reproduce:
1.name a variable 
2.enter 
3.call when needed

Actual Results:  
Holds a number or text until ask for. And can be changed.

Expected Results:
Name a variable. then store number or text in it. Not effected when sheet is calculated.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Thanks for such a great product. 


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
Comment 1 Regina Henschel 2018-01-02 23:20:34 UTC 
Calc has a feature which is called "Named Expression". Calc does not need Basic for that. Please use a mailing list or a forum, if the help is not sufficient to learn how to use it.

Feel free to reopen the bug report, if that feature is not suitable for you. Please explain in more details, how you will use such "variable", in that case.