View Issue Details

IDProjectCategoryView StatusLast Update
0003272ExpressionsGeneralpublic2021-02-06 06:30
Reporterbgoodr Assigned To 
Status newResolutionopen 
Product Version0.17 
Target Version0.20 
Summary0003272: Failed to parse expression occurs when referencing an alias in an external spreadsheet document
DescriptionVersion info:

OS: Ubuntu 17.04
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.17.12643 (Git)
Build type: None
Branch: master
Hash: 868d9cc6c215ce3a2ab20d454378ec00e1b9ed26
Python version: 2.7.13
Qt version: 4.8.7
Coin version: 4.0.0a
OCC version: 7.1.0
Locale: English/UnitedStates (en_US)

By "external" I mean a spreadsheet that is not a part of the FreeCAD document I am working on. I am choosing to use a separate master spreadsheet because I want that central spreadsheet to control dimensions in constraints used in sketches in multiple FreeCAD documents in the current working directory, such that when I update the values in the "master spreadsheet", the objects in the dependent FreeCAD documents are updated (well, right now they are not updated automatically, and I have to press a button in Assembly2, but that is off-topic from this bug).

After working around the bug in 0003271 by manually opening the external spreadsheet file, the fx button does seem to show that it recognizes the syntax and even shows the value, but when I click ok to use that value, I get a "Failed to parse expression" error.

Use the same attachments as in 0003271

The GIF in 0003271 also shows this problem.
Steps To Reproduce
  1. Extract the tarball.
  2. cd into the directory that is extracted so that the current working directory can resolve paths to other files in the set of files.
  3. Open up the file: freecad-daily UpsideDownMonitorMount.fcstd
  4. Open up the Leg.fcstd file using the button.
  5. Open up the MasterSpreadshet.fcstd to work around the bug in 0003271
  6. Double click on the sketcher
  7. Double click on the constraint with 1.5yd ("Shelf Depth")
  8. Click on the fx button.
  9. Type in a reference to the alias that is in the spreadsheet: MasterSpreadsheet#Spreadsheet.Sd
  10. Notice it says Result: 12.00 " which is correct: the spreadsheet has 12in in the Sd alias
  11. Click Ok
  12. Notice the Length field also shows 12.00 " which is correct so far.
  13. Click Ok
  14. Now see a popup error with window title "Dimensional constraint" and "Failed to parse expression". There is also "Failed to parse expression" in the Report view.
Tagsexpressions, spreadsheet
FreeCAD Information


related to 0003271 closedrealthunder Relative file references give 'Document not found' unless that file is opened first 
related to 0002477 assignedrealthunder Copy of sub objects with expression pointing to a spreadsheet shall not create a new spreadsheet 



2017-11-27 12:05

administrator   ~0010478

per the workflow that we ask bug reporters (big yellow banner at the top of this page), please discuss this in the forum before you open a ticket. Nevertheless, since this report took time and effort, we can tackle it here.
@chrisb care to weigh in?


2017-12-09 12:20

administrator   ~0010552

Last edited: 2017-12-09 12:50

Forum thread:


2022-03-03 13:55

administrator   ~0016585

This ticket has been migrated to GitHub as issue 5750.

Issue History

Date Modified Username Field Change
2017-11-27 01:32 bgoodr New Issue
2017-11-27 03:00 Kunda1 Description Updated
2017-11-27 03:00 Kunda1 Relationship added related to 0003271
2017-11-27 12:05 Kunda1 Note Added: 0010478
2017-12-09 12:20 Kunda1 Note Added: 0010552
2017-12-09 12:20 Kunda1 Steps to Reproduce Updated
2017-12-09 12:46 Kunda1 Tag Attached: expressions
2017-12-09 12:46 Kunda1 Tag Attached: spreadsheet
2017-12-09 12:50 Kunda1 Note Edited: 0010552
2017-12-09 13:03 Kunda1 Relationship added related to 0002477
2017-12-13 15:27 Kunda1 Project Sketcher => Expressions
2017-12-13 15:27 Kunda1 Category Bug => General
2021-02-06 06:30 abdullah Target Version => 0.20