View Issue Details

IDProjectCategoryView StatusLast Update
0003560SpreadsheetBugpublic2021-11-24 15:22
Reporterlokomoko Assigned Toeivindkvedalen  
PrioritynormalSeverityminorReproducibilityalways
Status confirmedResolutionopen 
Product Version0.17 
Target Version0.20 
Summary0003560: Renaming alias in spreadsheet changes the spreadsheet part of the reference from label to internal name
DescriptionRenaming an alias in a spreadsheet changes the spreadsheet-part of a reference to the alias from Label (e.g. "MyInputData") to internal name/Id (e.g. "Spreadsheet001").

Discussed in Forum under Renaming alias in spreadsheet changes the name of the spreadsheet in any reference
Steps To Reproduce1. Create new document
2. In spreadsheet workbench create a spreadsheet by the name "MyData"
3. Create cell with an alias e.g. "BoxSize" and a value
4. In part workbench create a 3D-object (e.g. cube) and therein a reference to the alias (e.g. "=MyData.BoxSize").
5. In spreadsheet change name of alias to BoxLength

Actual Result: The reference in the 3D-Object is "=Spreadsheet001.BoxLength" now, that is the alias was changed, but also the name of the spreadsheet
Expected Result: The reference in the 3D-Object should be "=MyData.BoxLength"
Additional InformationOS: Ubuntu 16.04.5 LTS
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.17.13528 (Git) AppImage
Build type: None
Branch: releases/FreeCAD-0-17
Hash: 5c3f7bf8ec51e2c7187789f7edba71a7aa82a88b
Python version: 2.7.6
Qt version: 4.8.6
Coin version: 4.0.0a
OCC version: 7.3.0
Locale: German/Germany (de_DE)
Tagsequation, expressions, formula, spreadsheet

Activities

lokomoko

2018-08-15 12:41

reporter   ~0011625

Direct link to forum topic Renaming alias in spreadsheet changes the name of the spreadsheet in any reference

wmayer

2018-11-11 11:27

administrator   ~0012176

When renaming an alias then at some point the functions Document::renameObjectIdentifiers, DocumentObject::renameObjectIdentifiers, PropertyExpressionEngine::renameObjectIdentifiers and ObjectIdentifier::relativeTo are called.
Because the ObjectIdentifier hasn't explicitly set documentObjectName it gets the (internal) name from the pointer to the DocumentObject.

yorik

2022-03-03 13:55

administrator   ~0016635

This ticket has been migrated to GitHub as issue 5800.

Issue History

Date Modified Username Field Change
2018-08-15 12:28 lokomoko New Issue
2018-08-15 12:28 lokomoko Tag Attached: equation
2018-08-15 12:28 lokomoko Tag Attached: expressions
2018-08-15 12:28 lokomoko Tag Attached: formula
2018-08-15 12:28 lokomoko Tag Attached: spreadsheet
2018-08-15 12:41 lokomoko Note Added: 0011625
2018-08-17 13:39 Kunda1 Description Updated
2018-11-11 11:27 wmayer Assigned To => eivindkvedalen
2018-11-11 11:27 wmayer Status new => confirmed
2018-11-11 11:27 wmayer Note Added: 0012176
2021-02-06 06:50 abdullah Target Version => 0.20
2021-11-24 15:22 chennes Project FreeCAD => Spreadsheet