Excel problem – prikazuje formulu, ne rezultat

Kod mene je to da prikazuje pointer ka ćeliji u kojoj je vrednost koju treba da prikaže, a umesto toga u ćeliji piše “=AJ33”.
Napominjem da se ovo dešava samo za NEKE ćelije, ne za sve.

Šta može da se uradi :
1. Proveriti da u ćeliji nije slučajno neki blanko ” ” ili apostrof “‘”. U oba slučaja Excel sadržaj ćelije automatski prikazuje kao tekst.
2. Iako nema blanka ispred znaka jednakosti Excel formule, staviti kursor ISPRED “=” i lupiti jedan backspace (kao da je blanko tu). Ume da pomogne
3. Proveriti da nije ćelija stavljena na “Text”. Postaviti tip ćelije na “General”, ući sa F2 u ćeliju (OBAVEZNO!) i pritisnuti “Enter”

Dobar link

Podaci o članovima domena

Kompjuter sa kog se ovo radi MORA biti u domenu, a korisnik koji je logovan mora imati makar READ prava nad domenom.

1. U polje “Start a search” ukucati “Admistrative tools”

2. Kliknemo na to i dobijamo :

3. Nas interesuje stavka “Active Directory Users and Computers” :

4. Za pretragu se uradi desni klik nad imenom domena, i odabere opcija “Find”

WIN prava nad folderima

Kako videti prava nad folderima, osim klasičnim metodom : desni klik na folder/Properties/Security?
Ovo nije baš uvek zgodno, jer je prozor mali i ne vidi se sve niti lepo niti sve odjednom.

Mnogo je lakše to gledati kroz komandnu liniju :
C:\Users\velda>icacls \\folder1\folder2\folder3
\\folder1\folder2\folder3 domen1\korisnik1:(OI)(CI)(RX)
domen1\korisnik2:(OI)(CI)(F)
domen1\korisnik3:(OI)(CI)(RX)
domen1\grupa1:(OI)(CI)(RX)
domen1\grupa2:(OI)(CI)(F)
Successfully processed 1 files; Failed processing 0 files

Evo značenja gornjih oznaka :
iCACLS inheritance settings :
(OI) — object inherit, this ACE will be inherited by objects placed in this container.
(CI) — container inherit, this ACE will be inherited by subcontainers placed in this container
(IO)  —  inherit only;
(NP)  —  don’t propagate inherit, this ACE will be inherited by objects and subcontainers one level deep – it will not apply to things inside subcontainers.
(I)  — permission inherited from the parent container, this ACE was inherited from the parent container.
ACE – access control entries

List of basic access permissions :
D  —  delete access;
F  —  full access;
N  —  no access;
M  —  modify access, user has the right to write and modify file system objects in this directory
RX  —  read and eXecute access;
R  —  read-only access;
W  —  write-only access

Detailed permissions :
DE  —  delete;
RC  —  read control;
WDAC  —  write DAC;
WO  — write owner;
S  —  synchronize;
AS  —  access system security;
MA  —  the maximum allowed permissions;
GR  —  generic read;
GW  —  generic write;
GE  —  generic execute;
GA  —  generic all;
RD  —  read data/list directory;
WD  —  write data/add file;
AD  — append data/add subdirectory;
REA  —  read extended attributes;
WEA  —  write extended attributes;
X  —  execute/traverse;
DC  —  delete child;
RA  —  read attributes;
WA  —  write attributes.

Dobri sajtovi : link1, link2

NTFS fajl sistem i WIN 10
Ili ono što se vidi kad se na folder klikne desni klik/Properties/Security :

Full control: Allows users to read, write, change, and delete files and subfolders. In addition, users can change permissions settings for all files and subdirectories.
Modify: Allows users to read and write of files and subfolders; also allows deletion of the folder.
Read & execute: Allows users to view and run executable files, including scripts.
List folder contents: Permits viewing and listing of files and subfolders as well as executing of files; inherited by folders only.
Read: Allows users to view the folder and subfolder contents.
Write: Allows users to add files and subfolders, allows you to write to a file.

WORD problem pri otvaranju fajla : “word file is corrupted and cannot be opened”

Evo šta se može probati :

Method 1 Try another app
Try to open your text file in Notepad or Wordpad.
You can also open the file in alternative programs : OpenOffice, LibreOffice or something else.

Metod 2 : probati da se dokument otvori uz opciju “Open and Repair”

Method 3: Changing the ‘Trust Center’ setting: The enabled protected view setting under ‘Trust Center’ prevents the Word file from opening. Follow the below mentioned steps:

Open your MS Word application -> Click on File and Option -> Select the ‘Trust Center’ and hit button under ‘Trust Center Settings’ -> Click on Protected View and uncheck all options available under this option and press ‘OK’ to confirm -> Restart MS Word and try to open your corrupt Word file.

Method 4: Manual Setting of ‘Component Security’: To change these setting to default setting, following steps are used:

Go to ‘Start’ and in search box, type as ‘dcomcnfg’. Then select ‘dcomcnfg’ from the program list
Go to navigation pane and expand the ‘Component Services’
Now right click on ‘My Computer’ and then click ‘Properties’
Open ‘Default Properties’ tab and set the following values, Default Authentication Level: Connect, Default Impersonation Level: Identify
Then, hit ‘OK’

Ako ništa od ovoga ne pomogne (a meni nije), probati : Yodot DOC Repair tool
Ovaj alat se NARAVNO plaća, ali ako vam treba za 1 doc fajl onda može da posluži i trial verzija.
Ovako izgleda kad javlja da je popravljen fajl :

Na žalost meni ni to nije pomoglo 🙁

DiskInternals Word recovery opet može samo trial verzija, ali on skenira ceo disk!!! Umesto da ga uperimo na jedan fajl 🙁

Kernel for Word Repair opet koristimo trial verziju. Dobro je to što se odabira željeni fajl, i sređenu verziju stavlja na odabrano mesto. Loše je to što mi nije spasao podatke.

Odličan link1 i još jedan link2

Total Commander i SFTP konekcija

TC nema sam po sebi mogućnost za kreiranje SFTP konekcija.
To se omogućava kroz plug-in.
Dobro uputstvo za to se može naći na ovom linku.

E, jednom kad se to postavi, ne treba zaboraviti kako se dotle dolazi, pošto uopšte nije jednostavno.
Kliknuti na listu diskova, i odabrati stavku “Network Neighborhood” :


Ali WinScp ima ugrađenu opciju za SFTP protokol 🙂