All Projects FreeCAD  Addon Manager  Arch  Assembly  Draft  Expressions  FEM  File formats  GCS  OpenSCAD  Part  PartDesign  Path  Project Tools & Websites  Raytracing  Robot  Sketcher  Spreadsheet  TechDraw

View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004003SpreadsheetBugpublic2019-06-06 03:362021-11-24 15:28
Reportergrog Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
PlatformPCOSWindows 10OS Version1803
Product Version0.18 
Target Version0.20 
Summary0004003: Renaming spreadsheet no longer has any affect on field tags.
DescriptionI have one computer with v0.17 and I can reliably change the Spreadsheet. Typically I rename it to 'S' for less typing. On my other computer which I just upgraded to v0.18 I can no longer reference tags by my typical S.tagname. I have to state Spreadsheet.tagname. I marked it as major as it's serious enough for me to downgrade to regain the functionality.
Steps To Reproduce
  1. new file
  2. Select Spreadsheet workbench and click on the spreadsheet icon to create a new spreadsheet.
  3. Select spreadsheet on navigation window.
  4. type: F2 - S (To rename the spreadsheet to 'S')
  5. enter a number in a cell
  6. [CTRL][SHIFT]a - <cell tag name>
  7. now switch to Part workbench
  8. create a primitave part
  9. select one of it's dimensions,
  10. click on the calculation icon, and enter S.tagname. (This fails in v0.18 but works in v0.17)
  11. now try Spreadsheet.tagname (This works)

Thanks for an awesome program.
GROG
Additional InformationOS: Windows 10
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.18.16110 (Git)
Build type: Release
Branch: (HEAD detached at upstream/releases/FreeCAD-0-18)
Hash: f7dccfaa909e5b9da26bf50c4a22ccca9bb10c40
Python version: 3.6.6
Qt version: 5.6.2
Coin version: 4.0.0a
OCC version: 7.3.0
Locale: English/UnitedStates (en_US)
Tagsspreadsheet

Relationships

duplicate of 0003379 assignedeivindkvedalen Expressions Certain identifiers (like h, rad) cannot be used as names for constraints for usage in expressions 
related to 0004031 confirmed Expressions Crash upon solving expression referencing named Constraint 

Activities

Kunda1

2019-06-06 14:30

administrator   ~0013151

Last edited: 2019-06-06 14:30

 Moved to Expressions category.
@grog Please x-post this to the freecad forum to validate by the community (per our guidelines in the large yellow banner at the top of this page)

wmayer

2019-06-07 10:45

administrator   ~0013155

Forum link: https://forum.freecadweb.org/viewtopic.php?f=3&t=36877

According to the replies there you have to write <<S>> instead of S.

Kunda1

2019-06-19 22:34

administrator   ~0013265

Per @openBrain this seems to look like a dupe of 0003379

grog

2019-08-25 14:55

reporter   ~0013466

Thus far the answer is to avoid problem characters for naming.
Is there a simple way to change the Spreadsheet name and adjust the references to it? I created a nice collection of documents that can't be read in newer versions because of this bug.

yorik

2022-03-03 13:55

administrator   ~0016777

This ticket has been migrated to GitHub as issue 5943.

Issue History

Date Modified Username Field Change
2019-06-06 03:36 grog New Issue
2019-06-06 03:36 grog Tag Attached: spreadsheet
2019-06-06 14:28 Kunda1 Project FreeCAD => Expressions
2019-06-06 14:30 Kunda1 Status new => feedback
2019-06-06 14:30 Kunda1 Note Added: 0013151
2019-06-06 14:30 Kunda1 Note Edited: 0013151
2019-06-07 10:45 wmayer Note Added: 0013155
2019-06-19 22:34 Kunda1 Relationship added duplicate of 0003379
2019-06-19 22:34 Kunda1 Note Added: 0013265
2019-06-28 10:46 Kunda1 Relationship added related to 0004031
2019-08-25 14:55 grog Note Added: 0013466
2019-08-25 14:55 grog Status feedback => new
2021-02-06 06:30 abdullah Target Version => 0.20
2021-11-24 15:28 chennes Project Expressions => Spreadsheet