LibreOffice Help – 7.6/text/scalc/guide — Hebrew @ TDF Weblate - LibreOffice: Enter the following formula in cell A3: <item type="literal">=NOW()-A1</item>

Translation

Context calc_date.xhp par_id3145642 help.text

English

PqEkE

Hebrew

Needs editing

Skip

Context	English	Hebrew
borders.xhp par_id6342051 help.text	<image id="img_id7431562" src="media/helpimg/border_ca_7.png" width="1.2602in" height="1.1252in"><alt id="alt_id7431562">setting a thick line as a border</alt></image>
borders.xhp par_id5775322 help.text	Click the second <emph>Default</emph> icon from the left to set all four borders. Then repeatedly click the lower edge until a white line is shown. This removes the lower border.	Click the second \<emph\>Default\</emph\> icon from the left to set all four borders. Then repeatedly click the lower edge until a white line is shown. This removes the lower border.
borders.xhp par_id2882778 help.text	<image id="img_id8155766.00000001" src="media/helpimg/border_ca_8.png" width="1.2602in" height="1.1252in"><alt id="alt_id8155766.00000001">removing lower border</alt></image>
borders.xhp par_id8102053 help.text	You can combine several line types and styles. The last image shows how to set thick outer borders (the thick black lines), while any diagonal lines inside the cell will not be touched (gray lines).	You can combine several line types and styles. The last image shows how to set thick outer borders (the thick black lines), while any diagonal lines inside the cell will not be touched (gray lines).
borders.xhp par_id2102420 help.text	<image id="img_id5380718" src="media/helpimg/border_ca_9.png" width="1.2602in" height="1.1252in"><alt id="alt_id5380718">advanced example for cell borders</alt></image>
borders.xhp bm_id151630452717743 help.text	<bookmark_value>adjacent cells;remove border</bookmark_value>
borders.xhp hd_id861630451554176 help.text	Adjacent Cells
borders.xhp par_id231630451548190 help.text	This option becomes available when formatting a range of cells that already have borders and the new format defined for the range involves removing outer borders.
borders.xhp par_id931630451706604 help.text	By default the option <emph>Remove border</emph> is disabled and the borders at the edges of the selected range are left unchanged. Check this option if the borders at the edge of the selection should be removed.
borders.xhp par_id641630452272324 help.text	If the preset <emph>No Borders</emph> is chosen then the <emph>Remove border</emph> option is enabled.
calc_date.xhp tit help.text	Calculating With Dates and Times	Calculating With Dates and Times
calc_date.xhp bm_id3146120 help.text	<bookmark_value>dates; in cells</bookmark_value> <bookmark_value>times; in cells</bookmark_value> <bookmark_value>cells;date and time formats</bookmark_value> <bookmark_value>current date and time values</bookmark_value>	\<bookmark_value\>dates; in cells\</bookmark_value\>\<bookmark_value\>times; in cells\</bookmark_value\>\<bookmark_value\>cells;date and time formats\</bookmark_value\>\<bookmark_value\>current date and time values\</bookmark_value\>
calc_date.xhp hd_id3146120 help.text	<variable id="calc_date"><link href="text/scalc/guide/calc_date.xhp">Calculating With Dates and Times</link></variable>
calc_date.xhp par_id3154320 help.text	In $[officename] Calc, you can perform calculations with current date and time values. As an example, to find out exactly how old you are in seconds or hours, follow the following steps:	In $[officename] Calc, you can perform calculations with current date and time values. As an example, to find out exactly how old you are in seconds or hours, follow the following steps:
calc_date.xhp par_id3150750 help.text	In a spreadsheet, enter your birthday in cell A1.	In a spreadsheet, enter your birthday in cell A1.
calc_date.xhp par_id3145642 help.text	Enter the following formula in cell A3: <item type="literal">=NOW()-A1</item>	Enter the following formula in cell A3: =NOW()-A1
calc_date.xhp par_id3149020 help.text	After pressing the Enter key you will see the result in date format. Since the result should show the difference between two dates as a number of days, you must format cell A3 as a number.	After pressing the \<item type=\"keycode\"\>Enter\</item\> key you will see the result in date format. Since the result should show the difference between two dates as a number of days, you must format cell A3 as a number.
calc_date.xhp par_id3155335 help.text	Place the cursor in cell A3, right-click to open a context menu and choose <emph>Format Cells</emph>.	Place the cursor in cell A3, right-click to open a context menu and choose \<emph\>Format Cells\</emph\>.
calc_date.xhp par_id3147343 help.text	The <item type="menuitem">Format Cells</item> dialog appears. On the <item type="menuitem">Numbers</item> tab, the "Number" category will appear already highlighted. The format is set to "General", which causes the result of a calculation containing date entries to be displayed as a date. To display the result as a number, set the number format to "-1,234" and close the dialog with the <item type="menuitem">OK</item> button.	The \<emph\>Format Cells\</emph\> dialog appears. On the \<emph\>Numbers\</emph\> tab, the \<emph\>Number\</emph\> category will appear already highlighted. The format is set to "General", which causes the result of a calculation containing date entries to be displayed as a date. To display the result as a number, set the number format to "-1,234" and close the dialog with the OK button.
calc_date.xhp par_id3147001 help.text	The number of days between today's date and the specified date is displayed in cell A3.	The number of days between today's date and the specified date is displayed in cell A3.
calc_date.xhp par_id3150304 help.text	Experiment with some additional formulas: in A4 enter =A324 to calculate the hours, in A5 enter =A460 for the minutes, and in A6 enter =A5*60 for seconds. Press the Enter key after each formula.	Experiment with some additional formulas: in A4 enter =A324 to calculate the hours, in A5 enter =A460 for the minutes, and in A6 enter =A5*60 for seconds. Press the \<item type=\"keycode\"\>Enter\</item\> key after each formula.
calc_date.xhp par_id3149207 help.text	The time since your date of birth will be calculated and displayed in the various units. The values are calculated as of the exact moment when you entered the last formula and pressed the Enter key. This value is not automatically updated, although "Now" continuously changes. In the <emph>Data</emph> menu, the menu item <emph>Calculate - AutoCalculate</emph> is normally active; however, automatic calculation does not apply to the function NOW. This ensures that your computer is not solely occupied with updating the sheet.
calc_series.xhp tit help.text	Automatically Calculating Series	Automatically Calculating Series
calc_series.xhp bm_id3150769 help.text	<bookmark_value>series; calculating</bookmark_value> <bookmark_value>calculating; series</bookmark_value> <bookmark_value>linear series</bookmark_value> <bookmark_value>growth series</bookmark_value> <bookmark_value>date series</bookmark_value> <bookmark_value>powers of 2 calculations</bookmark_value> <bookmark_value>cells; filling automatically</bookmark_value> <bookmark_value>automatic cell filling</bookmark_value> <bookmark_value>AutoFill function</bookmark_value> <bookmark_value>filling;cells, automatically</bookmark_value>	\<bookmark_value\>series; calculating\</bookmark_value\>\<bookmark_value\>calculating; series\</bookmark_value\>\<bookmark_value\>linear series\</bookmark_value\>\<bookmark_value\>growth series\</bookmark_value\>\<bookmark_value\>date series\</bookmark_value\>\<bookmark_value\>powers of 2 calculations\</bookmark_value\>\<bookmark_value\>cells; filling automatically\</bookmark_value\>\<bookmark_value\>auto filling cells\</bookmark_value\>\<bookmark_value\>AutoFill;cells\</bookmark_value\>\<bookmark_value\>filling;cells, automatically\</bookmark_value\>
calc_series.xhp hd_id3150769 help.text	<variable id="calc_series"><link href="text/scalc/guide/calc_series.xhp">Automatically Filling in Data Based on Adjacent Cells</link></variable>
calc_series.xhp par_idN106A8 help.text	You can automatically fill cells with data with the AutoFill command or the Series command.	You can automatically fill cells with data with the AutoFill command or the Series command.
calc_series.xhp par_idN106D3 help.text	Using AutoFill	Using AutoFill
calc_series.xhp par_idN106D7 help.text	AutoFill automatically generates a data series based on a defined pattern.	AutoFill automatically generates a data series based on a defined pattern.
calc_series.xhp par_id3154319 help.text	On a sheet, click in a cell, and type a number.	On a sheet, click in cell, and type a number.
calc_series.xhp par_idN106CB help.text	Click in another cell and then click back in the cell where you typed the number.	Click in another cell and then click back in the cell where you typed the number.
calc_series.xhp par_id3145272 help.text	Drag the fill handle in the bottom right corner of the cell across the cells that you want to fill, and release the mouse button.	Drag the fill handle in the bottom right corner of the cell across the cells that you want to fill, and release the mouse button.

Loading…

None

String updated in the repository

English

Hebrew 49 characters edited Current translation Translated

a year ago

Browse all string changes

Things to check

XML markup

XML tags in translation do not match source

Reset

Glossary

English	Hebrew
No related strings found in the glossary.

String information

Context

calc_date.xhp
par_id3145642
help.text

Source string description

PqEkE

Source string location

calc_date.xhp

String age

a year ago

Last updated

a year ago

Source string age

a year ago

Translation file

he/helpcontent2/source/text/scalc/guide.po, string 147