Spreadsheet .Start.xyz, .End.xyz

Post here for help on using FreeCAD's graphical user interface (GUI).
Forum rules
and Helpful information
IMPORTANT: Please click here and read this first, before asking for help

Also, be nice to others! Read the FreeCAD code of conduct!
bgma1961
Posts: 107
Joined: Mon Apr 02, 2018 9:19 am

Spreadsheet .Start.xyz, .End.xyz

Post by bgma1961 »

Hello,

I have a problem with "Start.y", when I enter a value or a formula in the "Formula Editor" in
Properties: Start, the value does not change even if
I do a refresh (F5) / Mark to recompute / recompute object.

I have been able to reproduce the error which seems to be due to the fact that I entered
"Base / Placement / Position / z" = "<<Spreadsheet>> .FH_1"
If I press [Clear] and enter a value, it works.

I have seen the problem for quite some time now without being able to point it out.
then I saw posts: parametric object does not use linked values that gave me the idea to look at Spreadsheet.

https://forum.freecadweb.org/viewtopic.php?f=3&t=68872

/ Best regards BG

Code: Select all

OS: Windows 7 SP 1 (6.1)
Word size of FreeCAD: 64-bit
Version: 0.20.28918 (Git)
Build type: Release
Branch: master
Hash: e1f2685734
Python 3.8.13, Qt 5.12.9, Coin 4.0.0, OCC 7.5.3
Locale: Swedish/Sweden (sv_SE)
Attachments
1.png
1.png (103.28 KiB) Viewed 1325 times
2.png
2.png (1.97 KiB) Viewed 1325 times
3.png
3.png (16.92 KiB) Viewed 1325 times
Test7.FCStd
(11.4 KiB) Downloaded 31 times
User avatar
thomas-neemann
Veteran
Posts: 11801
Joined: Wed Jan 22, 2020 6:03 pm
Location: Osnabrück DE 🇩🇪
Contact:

Re: Spreadsheet .Start.xyz, .End.xyz

Post by thomas-neemann »

bgma1961 wrote: Mon May 23, 2022 9:37 pm ...
I didn't understand the question, there were problems with the alias in the spreadsheet. does it work if you use the cell directly?

Bildschirmfoto_2022-05-24_08-52-15.png
Bildschirmfoto_2022-05-24_08-52-15.png (18.49 KiB) Viewed 1252 times
Gruß Dipl.-Ing. (FH) Thomas Neemann

https://www.youtube.com/@thomasneemann5 ... ry=freecad
bgma1961
Posts: 107
Joined: Mon Apr 02, 2018 9:19 am

Re: Spreadsheet .Start.xyz, .End.xyz

Post by bgma1961 »

thomas-neemann wrote: Tue May 24, 2022 6:54 am
bgma1961 wrote: Mon May 23, 2022 9:37 pm ...
I didn't understand the question, there were problems with the alias in the spreadsheet. does it work if you use the cell directly?
No it does not work with <<Spreadsheet>> .B1 in "#Line.Base.Placement.Position.z".
If I enter a value directly in .z, it works.
As you can see, "# Line.Start.z has 2500mm <<Line001>> .End.y" but "<<Line001>> .End.y" = 0
User avatar
thomas-neemann
Veteran
Posts: 11801
Joined: Wed Jan 22, 2020 6:03 pm
Location: Osnabrück DE 🇩🇪
Contact:

Re: Spreadsheet .Start.xyz, .End.xyz

Post by thomas-neemann »

bgma1961 wrote: Tue May 24, 2022 8:48 am ...
in realthunder i can change the value
tn-Test7.FCStd
(12.31 KiB) Downloaded 25 times
Bildschirmfoto_2022-05-24_10-57-35.png
Bildschirmfoto_2022-05-24_10-57-35.png (37.63 KiB) Viewed 1204 times

OS: Ubuntu 20.04.1 LTS (XFCE/xubuntu)
Word size of FreeCAD: 64-bit
Version: 2022.111.30764 (Git) AppImage
Build type: Release
Branch: LinkDaily
Hash: ef3092bcbca5475eff4eb7ff7933eb3e9bbbe4b9
Python version: 3.9.9
Qt version: 5.12.9
Coin version: 4.0.1
OCC version: 7.5.3
Locale: German/Germany (de_DE)
Gruß Dipl.-Ing. (FH) Thomas Neemann

https://www.youtube.com/@thomasneemann5 ... ry=freecad
User avatar
thomas-neemann
Veteran
Posts: 11801
Joined: Wed Jan 22, 2020 6:03 pm
Location: Osnabrück DE 🇩🇪
Contact:

Re: Spreadsheet .Start.xyz, .End.xyz

Post by thomas-neemann »

bgma1961 wrote: Tue May 24, 2022 8:48 am ...
in 0.19.3 it also works after recompute
193.png
193.png (33.8 KiB) Viewed 1190 times
OS: Ubuntu 20.04.1 LTS (XFCE/xubuntu)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.24366 (Git) AppImage
Build type: Release
Branch: (HEAD detached at 0f9259c)
Hash: 0f9259cda103ae1824ac16c68ac9b4a0d54b05fc
Python version: 3.9.7
Qt version: 5.12.9
Coin version: 4.0.0
OCC version: 7.5.3
Locale: German/Germany (de_DE)
Gruß Dipl.-Ing. (FH) Thomas Neemann

https://www.youtube.com/@thomasneemann5 ... ry=freecad
jaisejames
Posts: 384
Joined: Sat Sep 24, 2016 6:51 am

Re: Spreadsheet .Start.xyz, .End.xyz

Post by jaisejames »

You can enter value directly in Start [<<Line001>> .End].
I think separate vector x,y,z value is not supported in expression.
Attachments
freecad vector.png
freecad vector.png (10.67 KiB) Viewed 1155 times
bgma1961
Posts: 107
Joined: Mon Apr 02, 2018 9:19 am

Re: Spreadsheet .Start.xyz, .End.xyz

Post by bgma1961 »

thomas-neemann wrote: Tue May 24, 2022 9:04 am
bgma1961 wrote: Tue May 24, 2022 8:48 am ...
in 0.19.3 it also works after recompute

OS: Ubuntu 20.04.1 LTS (XFCE/xubuntu)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.24366 (Git) AppImage
I tried in version 0.19.24291 and it works
I don't have 0.19.24366

OS: Windows 7 SP 1 (6.1)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.24291 (Git)
Build type: Release
Branch: (HEAD detached at 0.19.2)
Hash: 7b5e18a0759de778b74d3a5c17eba9cb815035ac
Python version: 3.8.8
Qt version: 5.12.9
Coin version: 4.0.0
OCC version: 7.4.0
Locale: Swedish/Sweden (sv_SE)
bgma1961
Posts: 107
Joined: Mon Apr 02, 2018 9:19 am

Re: Spreadsheet .Start.xyz, .End.xyz

Post by bgma1961 »

bgma1961 wrote: Tue May 24, 2022 9:39 am
thomas-neemann wrote: Tue May 24, 2022 9:04 am
bgma1961 wrote: Tue May 24, 2022 8:48 am ...
in 0.19.3 it also works after recompute

OS: Ubuntu 20.04.1 LTS (XFCE/xubuntu)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.24366 (Git) AppImage
I tried in version 0.19.24291 and it works
I don't have 0.19.24366

OS: Windows 7 SP 1 (6.1)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.24291 (Git)
Build type: Release
Branch: (HEAD detached at 0.19.2)
Hash: 7b5e18a0759de778b74d3a5c17eba9cb815035ac
Python version: 3.8.8
Qt version: 5.12.9
Coin version: 4.0.0
OCC version: 7.4.0
Locale: Swedish/Sweden (sv_SE)
I also tested "#Line.Start.x" which works but "#Line.Start.y" does not work

Code: Select all

OS: Windows 7 SP 1 (6.1)
Word size of FreeCAD: 64-bit
Version: 0.20.28918 (Git)
User avatar
thomas-neemann
Veteran
Posts: 11801
Joined: Wed Jan 22, 2020 6:03 pm
Location: Osnabrück DE 🇩🇪
Contact:

Re: Spreadsheet .Start.xyz, .End.xyz

Post by thomas-neemann »

bgma1961 wrote: Tue May 24, 2022 10:00 am ....
what should come out of it? I suppose there is an easier way. I haven't needed anything like this yet
Gruß Dipl.-Ing. (FH) Thomas Neemann

https://www.youtube.com/@thomasneemann5 ... ry=freecad
bgma1961
Posts: 107
Joined: Mon Apr 02, 2018 9:19 am

Re: Spreadsheet .Start.xyz, .End.xyz

Post by bgma1961 »

thomas-neemann wrote: Tue May 24, 2022 10:05 am
bgma1961 wrote: Tue May 24, 2022 10:00 am ....
what should come out of it? I suppose there is an easier way. I haven't needed anything like this yet
As you already know (Mail 2022-04-08), my .FCStd is ( 12479kb) very large to publish here. and consists of a number of floors and a number of walls on each floor. What should come out is to be able to change floor heights and wall plagiarism and wall thicknesses and more via parameters and more.
It does not work with Start.Y but with Start.X [BUG]?
This .FCStd is only an example of what is not working.
Post Reply