0004492: Spreadsheet deleted value remains in database

ID	Project	Category	View Status	Date Submitted	Last Update

0004492	Expressions	Bug	public	2020-11-13 15:44	2020-11-13 15:48

Reporter	AndrewCSP	Assigned To
Priority	normal	Severity	minor	Reproducibility	always
Status	acknowledged	Resolution	open
Product Version	0.19

Summary	0004492: Spreadsheet deleted value remains in database
Description	If I create a row in a spreadsheet and give the value an alias, say 'wireDia', then delete that row and create another row elsewhere, I cannot now use that deleted name in the new row. Worse still, if I access values in the model, wireDia is still listed as a value and can be used in the model, preserving its (unchangeable) last value. @openBrain has confirmed this bug exists in 0.19 Forum thread
Steps To Reproduce	Create a row in a spreadsheet and fill in the alias, eg wireDia. Delete the row Try and use that alias in a new row. Also, it is still possible to see and use that alias in a model.
Tags	spreadsheet

FreeCAD Information	OS: macOS 10.15 Word size of OS: 64-bit Word size of FreeCAD: 64-bit Version: 0.18.16146 (Git) Build type: Release Branch: (HEAD detached at 0.18.4) Hash: 980bf9060e28555fecd9e3462f68ca74007b70f8 Python version: 3.6.7 Qt version: 5.6.2 Coin version: 4.0.0a OCC version: 7.3.0 Locale: English/UnitedKingdom (en_GB)

Date Modified	Username	Field	Change
2020-11-13 15:44	AndrewCSP	New Issue
2020-11-13 15:44	AndrewCSP	Tag Attached: spreadsheet
2020-11-13 15:48	openBrain	Status	new => acknowledged
2020-11-13 15:48	openBrain	Description Updated	View Revisions