search

realthunder / FreeCAD

Link branch FreeCAD
Other
763 stars 45 forks source link

Spreadsheet equation not working properly[Problem] #949

Open gah5118 opened 7 months ago

gah5118 commented 7 months ago

Is there an existing issue for this?

Version

0.20 (Release)

Full version info

[code]
OS: Windows 10 build 19045
Word size of FreeCAD: 64-bit
Version: 2024.123.0.14555 (Git shallow)
Build type: Release
Branch: HEAD
Hash: 0c0f69ad4806682096b51f7669d5f1cb83f9c7d7
Python 3.11.7, Qt 5.15.6, Coin 4.0.1, Vtk 9.2.5, OCC 7.7.2
Locale: English/United States (en_US)
Installed mods: 
  * btl.backup1706838233.8951619 0.9.9
  * DynamicData 2.60.0
  * Freecad-Built-in-themes-beta 1.2.2
  * freecad.gears 1.2.0
  * Glass
  * Render 2024.1.23
  * ThreadProfile 1.89.0
[/code]

Subproject(s) affected?

Spreadsheet

Problem description

in main branch the following works correctly =0.75 / 2 * 1 in

it is giving an error

In regards to QOL when using aliases something that really bothers me with freecad (attempting to switch from fusion), is in order to type the expression, you have to click the function button (no hotkey), type out the spreadsheet name, then "." then whatever the variable is. wouldn't it make sense to get rid of the first box all together since the function box could simply contain whatever value you want? furthermore, either, skipping having to type "spreadsheet name" via having the software search out the alias (for whatever reason it also pulls up cell width and other irrelevant items); or at the very least, selecting a default spreadsheet and it will (unless specified by typing another name like we currently must) assume "spreadsheetname." prefix

Anything else?

I really want to like this program, as I am sick of companies lowering their value and raising their prices. I think this has a ton of potential and with better QOL / UI / and functional improvements; it will give the others a run for their money. keep up the amazing work; I'm making a donation to this project

Code of Conduct

realthunder commented 7 months ago

The expression syntax is extended in this branch to be similar to that of Python, which makes in a keyword. You can either use " or inch.

There is a default shortcut for expression entering. Just press =. When you are entering expression inside a spreadsheet, you can refer to its own alias directly. When you entering expression for a property of other objects, you need to be explicit about which spreadsheet you are referring to, because you can refer to any property from any objects, not just spreadsheet. So, it makes little sense to have a default spreadsheet. The auto complete function should be able to save you a lot of typing in many cases.