Problem description: it's an enhancement request I wanted to do some calculation involving physical constants, Planck constant, Boltzmann's constant, speed of light etc. Although is not difficult to write them in a cell and use them, it would be convenient if there was a "constants menu" under the "functions" having all the fundamental physical constants in order to use them in calculations. A webpage where most of them can be found is http://hyperphysics.phy-astr.gsu.edu/hbase/tables/funcon.html Operating System: All Version: 4.2.5.2 release
Created attachment 102673 [details] test ods file showing how to use Named Ranges Hi, you can use "Named Ranges" to do that. See my test file. Just prepare a sheet which contain all the Constants you want, first column are their names, second column are their values, and then "Insert-Names-Create", make sure "Left Column" is selected in the pop-up dialog. You can use the named ranges anywhere in the spreadsheet during your calculation.
Interesting approach, I didn't even knew the "named ranges". I've always putted the values in a cell and call the cell's index (letter-number) in the functions. Nevertheless I don't have a problem rather than an enhancement request. What I'm suggesting is calc to have them already integrated in the functions menu in order to easily refer to them in any spreadsheet, without having the user to search for the values, write them, name them etc. For example in the function menu we have "economical" "logigal" "mathematical" etc menus, we could have also a "constants" menu with all the basic constants. I believe that it can be easily implemented and would be a plus in usefulness.
ok, I set it to NEW as a feature request.