Nameštanje vremenske zone Centos 6.8

On CentOS the timezone is controlled by /etc/localtime file.

Delete the current localtime file under /etc/ directory

# cd /etc
# rm localtime
All Europe timezones are located under under the /usr/share/zoneinfo/Europe directory as shown below.

# ls /usr/share/zoneinfo/Europe/
Amsterdam Athens Berlin Bucharest Chisinau Gibraltar Isle_of_Man Kaliningrad Lisbon Luxembourg Mariehamn Moscow Paris Riga San_Marino Simferopol Stockholm Tiraspol Vaduz Vilnius Zagreb
Andorra Belfast Bratislava Budapest Copenhagen Guernsey Istanbul Kiev Ljubljana Madrid Minsk Nicosia Podgorica Rome Sarajevo Skopje Tallinn Ulyanovsk Vatican Volgograd Zaporozhye
Astrakhan Belgrade Brussels Busingen Dublin Helsinki Jersey Kirov London Malta Monaco Oslo Prague Samara Saratov Sofia Tirane Uzhgorod Vienna Warsaw Zurich
Note: For other country timezones, browse the /usr/share/zoneinfo directory

# cd /etc
# ln -s /usr/share/zoneinfo/Europe/
Now the timezone on your Linux system is changed to Belgrade time as shown below.

# ln -s /usr/share/zoneinfo/Europe/Belgrade localtime

# date

Open Office Kopiranje Visine Redova

AKo ste imali veliki broj redova i hteli da im promenite visinu najlakše je to uradit

tako da se selektuje određeni broj redova koji vam treba sa različitim visinama i onda se kopiraju.

Pa se selektuju redovi nad kojima se treba promeniti visina. i Uradi se paste special i izabere only formats.

Kopiranje datuma sa formatom u text EXCEL 2013

Ako ste došli u priliku da formatirani datum “25.03.2015.” iskoprate u novu ćeliju da biste iskoristili tekst kako je i prikazan

naišli ste na problem excel kopira vrednosti tj. 47342 .

Način da se ovo zaobiđe je sledeći:

U ćeliji A1 je formatiran datum “25.03.2015.” u novoj ćeliji kucajte formulu =TEXT(A1;”DD”&”.”&”MM”&”.”&”YYYY”)

i dalje raditi sa ćelijom koja ima tekst.

Provera greške u rezultatu formule Excel 2010 i noviji

Syntax

IFERROR(value,value_if_error)

Value     is the argument that is checked for an error.

Value_if_error     is the value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Remarks

  • If value or value_if_error is an empty cell, IFERROR treats it as an empty string value (“”).
  • If value is an array formula, IFERROR returns an array of results for each cell in the range specified in value. See the second example below.

Syntax

ERROR.TYPE(error_val)

The ERROR.TYPE function syntax has the following arguments:

  • Error_val    Required. The error value whose identifying number you want to find. Although error_val can be the actual error value, it will usually be a reference to a cell containing a formula that you want to test.
If error_val is ERROR.TYPE returns
#NULL! 1
#DIV/0! 2
#VALUE! 3
#REF! 4
#NAME? 5
#NUM! 6
#N/A 7
#GETTING_DATA 8
Anything else #N/A