Description: In two places in Calc, the term "whole numbers" is used. It seems that the meaning of "whole numbers" is ambiguous in English: it can refer to either integers or natural numbers (which is an ambiguous term in itself). https://en.wikipedia.org/wiki/Whole_number Using less ambiguous terms would leave less room for confusion. Steps to Reproduce: 1. See https://translations.documentfoundation.org/translate/libo_ui-master/scmessages/en/?checksum=0fd89ca7cdfc6d64 and https://translations.documentfoundation.org/translate/libo_ui-master/scmessages/en/?checksum=11a776c2e2a7fbc4 Actual Results: The ambiguous term "whole numbers" is used. Expected Results: A more specific term is used. Reproducible: Always User Profile Reset: No Additional Info: n/a
The first item is Data > Validity... > Allow = All values, Whole Numbers, Decimal, Date, Time, Cell range, List, Text Length, Custom. And "Integer" is the proper term here. The second was introduced with bug 126573 and actually Whole Number replaced by Integer in https://gerrit.libreoffice.org/c/core/+/167645 but not for the tooltip. Don't know how to show it, though. Tentative patch at https://gerrit.libreoffice.org/c/core/+/168395
No objection, so lets do it.
Heiko Tietze committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/199ffecd9586d3a8c3365bdbc979c93600f25899 Resolves tdf#161395 - Rename Whole Number to Integer It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
If Tuomas or others want to check and do changes in Help: $ git grep -ni 'Whole Number' source/text/sbasic/shared/03070700.xhp:37:<paragraph role="paragraph" id="par_id951642689912087">Before division both operands are rounded to whole numbers. The fractional part of the result is dropped.</paragraph> source/text/sbasic/shared/03090402.xhp:49:<paragraph id="par_id3148664" role="paragraph" xml-lang="en-US"> <emph>Index</emph>: Any numeric expression rounded to a whole number. <literal>Index</literal> accepts integer values starting at 1 that specify which of the possible choices to return.</paragraph> source/text/scalc/01/04060104.xhp:360:<paragraph id="par_id3147253" role="paragraph"><ahelp hid="HID_AAI_FUNC_ISEVEN">Tests for even numbers. Returns 1 if the number divided by 2 returns a whole number.</ahelp></paragraph> source/text/scalc/01/04060104.xhp:493:<paragraph id="par_id3153538" role="paragraph"><ahelp hid="HID_AAI_FUNC_ISODD">Returns TRUE (1) if the number does not return a whole number when divided by 2.</ahelp></paragraph> source/text/scalc/01/04060119.xhp:395:<emph>Fraction</emph> is a whole number that is used as the denominator of the decimal fraction.</paragraph> source/text/scalc/01/04060119.xhp:415:<emph>Fraction</emph> is a whole number that is used as the denominator of the decimal fraction.</paragraph> source/text/scalc/01/12120100.xhp:66:<paragraph role="tablecontent" id="par_id3147434">Whole numbers</paragraph> source/text/scalc/01/12120100.xhp:69:<paragraph role="tablecontent" id="par_id3154319">Only whole numbers corresponding to the condition.</paragraph> source/text/scalc/01/calculation_accuracy.xhp:101: <paragraph role="paragraph" id="par_id101643312991679">Cell A3 will show 00:10:00 if the default formatting [HH]:MM:SS is applied to the cell. However, cell A3 will show 00:09:59.999999 instead of expected 00:10:00.000000 if formatted using [HH]:MM:SS.000000 format string. This happens despite only whole numbers of hours and minutes were used, because internally, any time is a fraction of a day, 12:00 (noon) being represented as 0.5. </paragraph> source/text/scalc/01/exponsmooth_embd.xhp:213:<paragraph id="par_id0603201609412399" role="note" xml-lang="en-US">A value of 1 indicates that Calc is to determine the number of samples in a period automatically. <br/>A value of 0 indicates no periodic effects, a forecast is calculated with EDS algorithms. <br/>For all other positive values, forecasts are calculated with ETS algorithms.<br/>For values that not being a positive whole number, the functions will return the #NUM! Error.</paragraph> source/text/scalc/01/func_randarray.xhp:33:<paragraph role="paragraph" id="par_id511715616090373"><emph>Integers</emph>: (optional) returns whole numbers (TRUE) or decimal numbers (FALSE). Default is FALSE.</paragraph> source/text/scalc/01/func_randarray.xhp:38:<paragraph role="paragraph" id="par_id521715616457946"><input>{=RANDARRAY(10;4;10;50;1)}</input> returns an array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of whole numbers (integers).</paragraph> source/text/scalc/guide/validity.xhp:68:<paragraph role="paragraph" id="par_id3153011" xml-lang="en-US">If you select "Whole Numbers", values such as "12.5" are not allowed. Choosing "Date" allows date information both in the local date format as well as in the form of a <link href="text/sbasic/shared/03030101.xhp">serial date</link>. Similarly, the "Time" condition permits time values such as "12:00" or serial time numbers. "Text Length" stipulates that cells are allowed to contain text only.</paragraph> source/text/smath/01/03090800.xhp:51:<bookmark_value>whole numbers</bookmark_value> source/text/smath/01/03090800.xhp:339:<image id="img_id3147383" src="media/helpimg/starmath/op21418.svg" width="1cm" height="1cm"><alt id="alt_id3147383" xml-lang="en-US">Set of whole numbers Icon</alt> source/text/smath/01/03090800.xhp:344:<paragraph role="tablehead" id="par_id3149628" xml-lang="en-US">Set of whole numbers</paragraph> source/text/smath/01/03090800.xhp:345:<paragraph role="paragraph" id="par_id3149641" xml-lang="en-US"><ahelp hid="HID_SMA_SETZ">Use this icon to insert a character for the <emph>set of whole numbers</emph>.</ahelp> You can also do this by entering <emph>setz</emph> in the Commands window.</paragraph>