Download it now!
Bug 81198 - Request: "constants" in Calc menu
Summary: Request: "constants" in Calc menu
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: low enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Main-Menu Calc-Enhancements
  Show dependency treegraph
Reported: 2014-07-10 23:25 UTC by michalis
Modified: 2018-05-23 17:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

test ods file showing how to use Named Ranges (100.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-07-12 16:05 UTC, Kevin Suo

Note You need to log in before you can comment on or make changes to this bug.
Description michalis 2014-07-10 23:25:11 UTC
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

Operating System: All
Version: release
Comment 1 Kevin Suo 2014-07-12 16:05:33 UTC
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.
Comment 2 michalis 2014-07-12 19:17:12 UTC
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.
Comment 3 Kevin Suo 2014-07-13 01:08:57 UTC
ok, I set it to NEW as a feature request.