Techdraw Spreadsheet Tip

Discussions about the development of the TechDraw workbench
Laurie Hartley
Posts: 423
Joined: Mon Feb 27, 2017 5:33 am
Location: Australia

Techdraw Spreadsheet Tip

Post by Laurie Hartley »

I don't know if this is a known issue but it is something I have just discovered while importing a spreadsheet view into my drawing:-

I had a line in my first column which read:-
M18x105 M8.8 bolts with nut & washers.

I had to change it to:-
M18 by 105mm M8.8 bolt with nut and washers.

The lesson seemingly that Techdraw will not accept spreadsheet fields that include operators such as x and &. It will throw an error in the area at the bottom of the combo view.

This is probably pretty obvious to more expert users but I had to figure it out through trial. error and a little bit of intuition.
Last edited by Laurie Hartley on Sun Oct 02, 2022 8:59 pm, edited 1 time in total.
User avatar
Shalmeneser
Veteran
Posts: 5744
Joined: Wed Dec 23, 2020 12:04 am
Location: Fr

Re: Techdraw Spreadsheet Tip

Post by Shalmeneser »

Can you provide a minimal working example (MWE) ?
Laurie Hartley
Posts: 423
Joined: Mon Feb 27, 2017 5:33 am
Location: Australia

Re: Techdraw Spreadsheet Tip

Post by Laurie Hartley »

Shalmeneser wrote: Fri Sep 30, 2022 9:39 am Can you provide a minimal working example (MWE) ?
Yes - I am away from my computer but I will tomorrow.
rdinohio
Posts: 8
Joined: Thu Aug 23, 2018 1:48 pm

Re: Techdraw Spreadsheet Tip

Post by rdinohio »

Have you tried putting spaces between the numerical values, e.g. M 18 x 8.8?
chrisb
Veteran
Posts: 45735
Joined: Tue Mar 17, 2015 9:14 am

Re: Techdraw Spreadsheet Tip

Post by chrisb »

And please add where in TechDraw you want to reference the spreadsheet's value.
A Sketcher Lecture with in-depth information is available in English, auf Deutsch, en français, en español.
Laurie Hartley
Posts: 423
Joined: Mon Feb 27, 2017 5:33 am
Location: Australia

Re: Techdraw Spreadsheet Tip

Post by Laurie Hartley »

@Shalmeneser - example as promised.
@rdinohio - yes see file - it doesn't appear to make a difference.

I don't think it is a big deal really but could cause some confusion for people who use my sort of terminology.
Attachments
Techdraw_Spreadsheet.FCStd
(20.77 KiB) Downloaded 16 times
User avatar
Roy_043
Veteran
Posts: 5876
Joined: Thu Dec 27, 2018 12:28 pm

Re: Techdraw Spreadsheet Tip

Post by Roy_043 »

Confirmed, these characters need to be 'escaped' somehow.
Instead of & use: & or &
Instead of x use: x
User avatar
Shalmeneser
Veteran
Posts: 5744
Joined: Wed Dec 23, 2020 12:04 am
Location: Fr

Re: Techdraw Spreadsheet Tip

Post by Shalmeneser »

'x' : no problem
'&' : problem

'Plate with 4 x 12mm Holes & 50 x 12mm slot' : problem -> nothing visible
'Plate with 4 x 12mm Holes + 50 x 12mm slot' : no problem -> everything visible

TechDraw_SpreadsheetView
(I don't know for 0.21 because SpreadSheet crash each time I click in a cell)

Code: Select all

OS: Windows 10 Version 1809
Word size of FreeCAD: 64-bit
Version: 0.20.29177 (Git)
Build type: Release
Branch: releases/FreeCAD-0-20
Hash: 68e337670e227889217652ddac593c93b5e8dc94
Python 3.8.10, Qt 5.15.2, Coin 4.0.1, Vtk 8.2.0, OCC 7.6.2
Locale: French/France (fr_FR)
Installed mods: 
  * fasteners 0.4.3
  * fcgear 1.0.0
  * Manipulator 1.4.9
  * sheetmetal 0.2.56
User avatar
Shalmeneser
Veteran
Posts: 5744
Joined: Wed Dec 23, 2020 12:04 am
Location: Fr

Re: Techdraw Spreadsheet Tip

Post by Shalmeneser »

((KISS : keep it stupidly simple))
Attachments
Techdraw_Spreadsheet_SHALM.FCStd
(27.11 KiB) Downloaded 9 times
User avatar
Roy_043
Veteran
Posts: 5876
Joined: Thu Dec 27, 2018 12:28 pm

Re: Techdraw Spreadsheet Tip

Post by Roy_043 »

Shalmeneser wrote: Sat Oct 01, 2022 9:20 am 'x' : no problem
Confirmed.
Post Reply