Page 1 of 2
Spreadsheet .Start.xyz, .End.xyz
Posted: Mon May 23, 2022 9:37 pm
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)
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 6:54 am
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 (18.49 KiB) Viewed 1314 times
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 8:48 am
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
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 8:58 am
by thomas-neemann
bgma1961 wrote: ↑Tue May 24, 2022 8:48 am
...
in realthunder i can change the value
- Bildschirmfoto_2022-05-24_10-57-35.png (37.63 KiB) Viewed 1266 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)
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 9:04 am
by thomas-neemann
bgma1961 wrote: ↑Tue May 24, 2022 8:48 am
...
in 0.19.3 it also works after recompute
- 193.png (33.8 KiB) Viewed 1252 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)
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 9:27 am
by jaisejames
You can enter value directly in Start [<<Line001>> .End].
I think separate vector x,y,z value is not supported in expression.
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 9:39 am
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)
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 10:00 am
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)
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 10:05 am
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
Re: Spreadsheet .Start.xyz, .End.xyz
Posted: Tue May 24, 2022 10:28 am
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.