Sep
25
MS Excel 2007 multiplication bug
Filed Under error, Windows | Leave a Comment
Multiplication bug in Microsoft Excel 2007 has been reported to Microsoft.
How to verify if your Spreadsheet has the same problem?
Simply put =850*77.1 in any cell the correct result is 65,535, but MS Excel 2007 calculated it as 100000.
There are several other “buggy”combinations reported by other users:
What’s even stranger is this: Â Suppose the formula is in A1.
=A1+1 returns 100001, which appears to show the formula is in fact 100000
and a very Serious problem.
And if you multiply be say, 2 you get something else:
=A1*2
returns 131070, as if A1 had 65535. (which it should have been)
=A1*1
Keeps it at 100000.
=A1-1 returns 65534
=A1/1 is still 100000
=A1/2 returns 32767.5
Using MAX() on a range appears not to see 100000.
Sep
22
How to check where your Windows connects
Filed Under Howto, Windows | Leave a Comment
If your system is running slowly and you are concerned if it is connecting to some web sites the tip from Digital Inspiration will be very useful to you:
1. Type cmd in your Windows Run box.
2. Type “netstat -b 5 > activity.txt” and press enter. After say 2 minutes, press Ctrl+C.
3. Type “activity.txt” on the command line to open the log file in notepad (or your default text editor)
Then you will see all connections made from your computer to other servers.
TIP: When running the command better close you web browser and other programs connecting to internet known to you. Wait around a minute and start the test. This will reduce your false positives.
Aug
20
Vista cursors in XP
Filed Under Howto, Windows | Leave a Comment
Here is a tutorial how to bring some of the Vista look into XP.
This tutorial is for mouse cursors.
Thanks Alan.
Aug
17
Red Hat Developer Studio 1.0 (beta1)
Filed Under Linux, news, Windows | Leave a Comment
Red Hat Developer Studio 1.0 (beta1) is released for download and comments.
Red Hat Developer Studio is a set of eclipse-based development tools that are pre-configured for JBoss Enterprise Middleware Platforms and Red Hat Enterprise Linux.
Linux and windows versions are available.
The size of download (at least for Linux) is 530 MB.
Read installation manual for how to install.
TIP: to run jar archive issue
java -jar <jar archive>
at terminal.
Here is how it looks:
Aug
7
In the Net there are rumors that XP SP3 was released for beta testing together with Vista SP1.
SP3 was scheduled for 2005, but as usual we may receive it in beginning of 2008.
Jul
31
Firefox 2.0.0.6 – Second security patch for the month
Filed Under Fix, Linux, Windows | Leave a Comment
After hacker released to the public details about Firefox URI flaw Mozilla released new version of Firefox – 2.0.0.6 with following security issues fixed:
- Unescaped URIs passed to external programs
- Privilege escalation through chrome-loaded about:blank windows
First critical and second with moderate impact. Both connected with how Mozilla handle URI protocol.
Time to update again.
Jul
31
Open XML compatibility pack
Filed Under news, Windows | Leave a Comment
Microsoft made public Microsoft office 2007 compatibility pack.
This free software will allow users of Microsoft Office 2003, Microsoft Office 2000, and Microsoft Office XP to open, edit, and save files in new Open XML format introduced in 2007 version of Microsoft Office.
Download it now (~27 MB) – requires Live ID
Jul
23
Is it possible to crash Vista
Filed Under error, Windows | Leave a Comment
After the hype of security in marketing campaign run by Microsoft about new security “pearl” Vista, there are the first reports of how easily someone can crash the system….
Just press Win+E – this is well known shortcut for launching Explorer and hold it for 20 sec this will cause the launch of multiple Windows Explorer instances resulting lack of system resources and crash of the system.
Unfortunately this cannot be stopped in Task manager….
Wait for patch for MS and hope that somebody will not write a hoax using this vulnerability.
Jul
19
Versioning
Filed Under Howto, Linux, Unix, Windows | Leave a Comment
Have you already write the code and have the need to keep track of changes or keep different versions with possibility to revert easily to previous version?
Do you still have those problems?
If so the tool you may need is called subversion and is available for Linux/Unix/MAC OS X and Windows.
How to use it?
It is relatively easy especially if you create local repository:
1. You need to install the binary version or compile from source code (the procedure is described for CentOS 5, but sould not be drastically different for other OS’s except fro installation part)
yum install subversion
2. Next step is to create repository – it must be done on the machine where repository will reside
svnadmin create <path to local directory>
3. After you create repository next step is to import data
svn import <folder> <repository> -m "<log message>"
Where:
- folder – direcrtory where your data reside
- repository – file:///<path to repository> Note there are 3 slashes
- log message – something meaninfull probably something like “first import”
4. Rename the folder
mv folder folder.beforesvn
5. Create working copy of the data
svn checkout <repository> <working copy>
6. Start working and send changes to repository with
svn commit
Note that you need to be in “working copy” folder.