الأرقام العربية والأرقام الهندية في إكسل

بإمكان مايكروسوفت إكسل أن يكون أداة في غاية الفائدة وتجعلك تستمتع (تستمتعين) بمزاياه إلى حد كبير. لكن في بعض الحالات تتمكن أشياء صغيرة جداً من تحطيم هذه الصورة المشرقة، منها على سبيل المثال (لا الحصر) موضوع الأرقام العربية والهندية. حيث أن إكسل لا يمتلك نفس المزايا التي يتمتع بها الوورد ولا يمكن لذلك تحديد طريقة كتابة الأعداد بشكل منفصل في كل خلية (أو ملف) على حدة بشكل سهل. لذلك يقوم إكسل بقراءة الإعدادات من النظام (الخيارات الإقليمية في لوحة التحكم).

بالمختصر المفيد، إذا كان الخيار الافتراضي لديك هو الكتابة بالأعداد العربية ولسببٍ ما احتجت لاستخدام الأعداد الهندية فيمكنك عمل التالي:

  1. الضغط بالزر الأيمن على الخلية واختيار تنسيق الخلايا
  2. من علامة تبويب “أرقام” اختر/اختار “مخصص”
  3. أضف/أضيفي قبل الصيغة (أو المعادلة) العبارة التالية

 [$-2000000]

الخطوات

وسوف تتحول الأعداد إلى الشكل الهندي

Project 2003 Server Unknown Error

If you are running Project Server 2003 for EPM, and start to connect using the Project Professional, you may face errors filling up the Application log in the eventviewer. The error description is really unuseful, below is the error details:

Source: PjTraceSvc

Event ID: 2

Description: Lot of non useful information and something like:
C:OfficedevprojectWebClientsourceserverpjdbcommMain.cpp

However, you may find it deferent in file name, but still the same at the end.

If you look over the Internet, or in Microsoft KB you’ll find very few resources handling this, and even these resources do not address the same issue you have.

SO, what the hell is going on? Well, apparently the project server development team never bothers resolving this issue as Project 2007 is in the market. But if you are still running the 2003 version and this error really annoying, then here is the really bad news, you can (and in fact you should) ignore it as it has no effect at the operation of the server. All what this message USUALLY is tilling that someone (may be a PM) is trying to access/modify/update/delete an object which he/she doesn’t have an authority to do.
Yep, that is the story, I’m sorry but hopefully you didn’t spend more than three months moving from one expert to another to solve this issue as I did.
 

Forwarding to Another Mailbox Programmatically

If you usually try searching the MSDN offline then online and finally use the Google like I do when searching for a particular property in the Active Directory Schema, you may get into a situation where you are unable to find what you are looking for. Usually you get into this situation when you search using the displayed name in the graphical interface.

I was in the meddle of a big cross-forest “Exchange Server 2003” migration project where the “Migration Wizard” tool has failed me and gave me really hard time. While it was so success in the lab and testing, when we run it in production it kept working over 14 hours and finished less than %60 of the job. Where the tests assumed it will finish by less than 6 hours.

However, to work around the issue I had to develop a code to keep both Exchange organizations sync’d. And to make the operation semi-automated (specially with 2100+ mailboxes) I was looking for the attribute that allows me to set the forwarding information for the user object in AD. And as you expect, found nothing on the Internet nor in the MSDN library (maybe because I’m not a programmer- I’m just another MCSE J). So searching for “Forward to:” or “deliver messages to both forwarding address and mailbox” or “Forwarding Address” got me nothing. The alternate was by using a dummy user account, create a mailbox for it, and set that attribute to forward to my mailbox. Then using the ADSIEDIT tool (from the Support Tools on Windows CD) to find the “Forward to:” value in the user object. And found it under “altRecipient”. Then I assumed the “deliver messages to both forwarding address and mailbox” value would be a Boolean, and I was right. It was under ‘deliverAndRedirect”.

Oh yeah, need lot of work to find the attribute, but setting the value and search for it one by one is not really the best way, is it? So, doing some more search guided me to the right location (at least for Exchange), at http://msdn2.microsoft.com/en-us/library/ms873635.aspx

Enjoy it 🙂

OWA 2003 Shows Icons Placeholders and “Loading” Word

I’ve came to a situation where I was so close to format the front-end server for one of my clients as it won’t work fine in the OWA interface.
Basically, there was a big issue for the SSL, and it didn’t work till I removed the IIS and re-installed it totally. Ofcourse, I’d to re-install the Exchange Server 2003 and the SP2 for it. I guess I did a mistake some where while following the article (http://support.microsoft.com/kb/320202) and then get no help on the net for the issue, but found hundreds of people asking for a solution. Found tons of articles for Exchange 2000 but nothing of it would fix the issue till find this article which doesn’t appear in Google search (don’t ask me I’ve no idea why) http://support.microsoft.com/kb/910119/en-us
I wish others would find it useful and not waste the same time I did. I spent over 12 continuous hours, and left the client site at 5:00 AM where the temperature was less than 5 degrees outside, and had to come next day to finish it.

IIS Admin Console Cannot be Found

At one site of a customer, where running Exchange Server 2003 on top of Windows Server 2003, faced a problem with the IIS manager. The MMC console doesn’t find it, you cannot add the snap-in because it’s not there. Removing/re-installting the IIS is not an option because the E2K3 is there.

I thought there must be some DLL registration missing, similar to the Schema Admin add-in, where you need to manually register the schmmgmt.dll file (run regsvr32 schmmgmt.dll). So keep searching till found the inetmgr.dll under the %windows%system32inetsrv folder.