I am attempting to work through a backlog
of Spreadsheet module bugs, and have come across bug report 3255
. Rather than revive this old help thread
on the topic, I thought it would be more prudent to start a new thread in the Open Discussion forum.
Continuing from the discussion in the linked help thread: Despite the fact that "fx" and "value" use different parsers, I think it is critical that the user experiences consistent behaviour.
Further, the convention with calculators seems to be to allow the user to set a global angle default (Deg or Rad) to be used in these trigonometric functions. These globals can be overridden on certain calculators by specifying the unit in the calculation.
You can see some of what I'm talking about in this video
, though in the video he prefers to set the calculator mode versus over-writing the default.
in te TI36x user manual describes how the user can input an angle unit to over-ride the default value.
Therefore, I propose that within the FreeCAD preferences we allow the user to specify an angle "mode" (i.e. degrees or radians) which will be used in all trigonometric functions.
For expressions that understand units, the user can over-ride this default unit type. for expressions that don't understand units, the user can expect the default unit-type to be used.
If there is some general consensus that this behaviour is reasonable, I can prepare a PR to implement this feature.