Bug 114807

Summary:	Adding a variable within Calc.
Product:	LibreOffice	Reporter:	Mark Mclean <mclean8414>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED WORKSFORME
Severity:	enhancement	CC:	rb.henschel
Priority:	medium
Version:	5.4.4.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

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.