Linux.com

Home Linux Community Community Blogs

Community Blogs



Excel no longer able to multiply correctly - better use OpenOffice

You know it’s bad for Microsoft’s financial department, especially with the kind of numbers they crunch, when they can’t even perform basic multiplication. Seriously, people. it’s been 20 years, figure it out.

What am I talking about?

The “Excel 2007 Multiplication Bug,” as outlined on Slashdot:

“The example that first came to light is =850*77.1 - which gives a result of 100,000 instead of the correct 65,535. It seems that any formula that should evaluate to 65,535 will act strangely. One poster in the forum noted these behaviors: ‘Suppose the formula is in A1. =A1+1 returns 100,001, which appears to show the formula is in fact 100,000… =A1*2 returns 131,070, as if A1 had 65,535 (which it should have been). =A1*1 keeps it at 100,000. =A1-1 returns 65,534. =A1/1 is still 100,000. =A1/2 returns 32767.5.’”

How many ways do I love open source? Let me count the ways. But not in Excel.

And before you get ahead of yourself, OpenOffice does this calculation properly:

Better switch to open source if you are doing any important financial spreadsheets.

 This bug was fixed by microsoft later but what will happen to those users who are still using the buggy microsoft excel... I can only imagine :)

I just love Open Source :)

 

Steps Forward !


I liked the way of the new Linux.com. As a community portal and integration of software and the news from Linux world is the the way that it should be.

I hope this aim will keep on covering linux users all around the world, and i wish Linux.com will  be %100  browser and os friendly for us. We do not like more flash animations&ads heavy scripts will be not good for many users.

And this editor Rocks light and easy to use.
I have best wishes for new Linux.com

And tihis is the end of my first log.

Roger that.

 

linux user group for east tenesssee

looking for a user group in morristown,tn or jefferson city, tn or people in this area who would like to start linux user group
 

LinMinTM Bare Metal Provisioning 5.4 adds Turbo-ImagingTM and Hosting, Cloud Data Center Enhancements

 

Hosting, Cloud and Corporate Data Center Customers Drive Extensive List of Enhancements

 

REDWOOD CITY, Calif. - May 20, 2009 - LinMin, maker of award-winning LinMin Bare Metal ProvisioningTM, today unveiled Release 5.4, featuring "Turbo-Imaging," a high-performance disk imaging subsystem for disaster recovery, new operating system media management, updated Linux® and Windows® Server provisioning, extensive logging and numerous other features requested by corporate, cloud and hosting company data center managers.

 

Turbo-Imaging brings disaster recovery to a new level with automatic file system detection, intelligent compression and other capabilities that make it easy for data center managers to quickly roll systems back to a known-good state in case of software corruption, malicious attack or other failure. Combining server provisioning (remote, unattended operating system installation) and disk imaging in a single product makes LinMin an indispensable solution in deploying, repurposing and recovering the commodity hardware infrastructure layer used in hosting, corporate, cloud and other data center environments.

 

"We use LinMin extensively in our three hosting data centers for provisioning and imaging our Linux and Windows servers," said Andrew Cartwright, CTO of FiberHosting. "We are now implementing LinMin's application programming interface (API) to enable FiberHosting customers with dedicated servers to control their systems from the bare metal up. This increases customer satisfaction and reduces our own operating expenses."

 

"The positive feedback we're getting from customers is most gratifying," said Laurent Gharda, CEO and founder of LinMin Corp. "There is no substitute for hosting, cloud and corporate data center staff feedback to drive LinMin's roadmap for solving real world problems. As new vendors and solutions emerge to manage already-deployed physical and virtual systems, the forgotten piece of the data center cost equation remains the labor-intensive deployment, re-purposing and recovery of the hardware layer itself. LinMin helps customers optimize exactly that."

 

Pricing:

LinMin Bare Metal Provisioning 5.4 is available immediately and is available for purchase and download at http://www.linmin.com/.  LinMin Bare Metal Provisioning for Linux and Windows is priced at $249 for up to 10 client systems, $999 for up to 100 client systems, $1,999 for up to 250 client systems, $3,499 for up to 500 client systems and $5,999 for up to 1,000 client systems.

 

About LinMin:

LinMin provides software that remotely provisions and images Linux and Windows on servers, blades, PCs, appliances and virtual machines. LinMin Bare Metal Provisioning (LBMP) is the industry's only truly affordable system provisioning and imaging solution that can be implemented by IT organizations of any size with very limited budgets. LinMin is based in Redwood City, Calif. with development and QA offices in Menlo Park and San Rafael, Calif. For more information, please visit http://www.linmin.com/.

 

 

 

Hello Linux World!!

Hello from Turkey. 

 

Experiences with KDE 3 and 4

I have been using KDE 3 for a number of years now, and I have been testing KDE 4 on and off for about two years.  Over the past two years, I have had test systems containing KDE 4, but about a month ago I replaced KDE 3.5.10 on my main system with KDE 4.2.2 (on sidux, which uses Debian Sid packages).

There were a few issues at first, but the desktop continues to improve, and it is usable enough for me to use on a regular basis.  I do have other desktop and window environments available in the now unlikely event that I run across a serious problem, but I've had the system running continually this session for 2 1/2 days, and I've run it for a couple of days in a row before - now to run it with some longevity and make sure it still holds up.

I was also curious to see how well KDE 4 can do on older hardware.  I have a Dell Dimension 4100, containing a 1 GHz Pentium 3 processor and 256 MB of RAM.  I started it up last night, updated one distribution on it with the latest KDE 3.5.10 software and noticed that while it was not fast and it had some swapping, it was not terrible and it actually worked fine, just not as fast as my most current Duo Core systems with 2 GB of memory.  I wanted to see if KDE 4.2.2 would do as well, so I upgraded my sidux instance on that system and started KDE.  It still works fine, so a Pentium 3 with 256 MB RAM remains a viable platform for using the current implementation of KDE.

 

Order By Date in MySQL

Suppose you write a query to sort a table by date field.

SELECT aDate FROM aTable ORDER BY aDate 

The above query should sort aDate column in ascending order. But it doesnt work the way it should.
To sort date field in MySQL use following query:

SELECT DATE_FORMAT(aDate, '%d-%M-%Y'AS aDate, aDate AS sDate FROM aTable ORDER BY sDate 

 

 

Uploading files with PHP

During my recent project I learned about uploading files using. For uploading files with PHP first step is to create a HTML form:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">  <HTML>  

<BODY>    <FORM METHOD='POST' ACTION='upload.php' ENCTYPE='multipart/form-data'> 

<INPUT NAME="image" TYPE="file" />           <INPUT TYPE='Submit' VALUE='Upload' />  

</FORM>  

</BODY>

</HTML> 

 

 

For form the attribute ENCTYPE='multipart/form-data' is very important.

Next step is to create a PHP script upload.php which will upload the file:

 

<?php  
// Path where the file will be uploaded  
$target_path = "/var/www/";  
 
$file  = $_FILES['image'];  
$temp = $file['tmp_name'];  
if(is_uploaded_file($temp))  
{  
   if(move_uploaded_file($temp, $target_path.$file['name']))  
   {  
      echo "Upload successfull.";  
      echo "File type is: ".$file['type'];  
      echo "File size is: ".$file['size']/1024. " kb";  
   }  
   else  
   {  
      echo "File cannot be moved to $target_path";  
   }  
}  
else  
{  
  echo "Unable to upload!";  
}  
 
?> 


The target path given is an absolute path. I tried to give relative path but it didnt work. If you are using windows you can give path like "c:\\some_directory\\".

 

Linux Screenshots

Hello,

Here is a whole page of screen shots of Linux Distributions

by cybormoron: 

http://jmjlinux.110mb.com/screenshots1.html
  • Screenshot/slideshow of Slackware 12.2 install
  • Here are some screenshots of Vector Linux 5.9 Gold Edition
  • How to create a virtual machine with Virtual Box
  • Slackware and D Small Linux in Virtual Box
  • Freespire in Virtual Box
  • PCLinuxOS in Virtual Box
  • Wolvix in Virtual Box
  • Debian in Virtual Box 
 

On email account recovery (how to make it not stupid)

This great article by John Timmer and a discussion with Aaron Toponce on Identica provoked this blog entry.

There's been some talk about "security" questions and how they are used to allow access to your email account when you forget your password. Generally you have a few obvious options that anyone could dig up with a few minutes on the Internet. Gmail takes it a step further and lets you create your own question. I can confidently say these measures are worthless to the average user.

Instead, I'll tell you how I sidestep the problem and keep your email account accessible to you and safe from snoopers who looked up what street you grew up on.

Pick a random file, preferably a big one that you have the only exact copy of. Run it through sha1sum (or any reasonable hash function). See where I'm going? Save that hash in a text file somewhere safe, on multiple computers or media is possible. That hash is your first/favorite pet's name. Or your mother's maiden name. Or your favorite color when you were 7.

You see what you did there? The answer to the security question is virtually unguessable now. I don't care how savvy the social engineers are or how strong their Google-fu might be. No one is going to find that hash in Wikipedia. You have changed the security question from a second password (a "something you know" factor) to a token you have to posess (a "something you have" factor). Multi-factor authentication FOR THE WIN.

But let's go a step further. Someone could gain access to wherever you stored the text file that holds the hash. You can't email the file to yourself, because (1) you have to trust your email host to prevent unauthorized access to your email and (2) you need access to your email to get access to your email (Catch-22). You need to encrypt the file.

I use Gnu Privacy Guard for this step. Since I already have a key, I can just encrypt the file to myself. At this point I can store copies everywhere, even where others might have access!

If you're using Gmail and want a reminder where you have your hash token, pick this for your question: "What's in emailemergency.txt.gpg?" If you're sneaky, put something like "Am I right-handed?"

Congrats. You have just taken a stupid insecure system and made it useful. I hope you like it.
 

Avoid common querying mistakes with better Django models

This article sheds light on some of the lesser-known features of the Django ORM in particular, but SQLAlchemy users may find some of the cautions about inefficient query generation applicable to their own code. Learn how to avoid common querying mistakes, use model managers to encapsulate complex queries, and take advantage of the powerful new aggregation features available in Django V1.1
 
Page 117 of 142

Upcoming Linux Foundation Courses

  1. LFD331 Developing Linux Device Drivers
    13 Oct » 17 Oct - Virtual
    Details
  2. LFS425 Linux Performance Tuning Crash Course
    16 Oct » 16 Oct - Düsseldorf, Germany
    Details
  3. LFS220 Linux System Administration
    20 Oct » 23 Oct - Virtual
    Details

View All Upcoming Courses


Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board