I also have one other question. Though I'm sure it's in the libre preferences somewhere. The date likes to display what it wants rather than what I want. Example: I would like it to say April 11, 2012 but Libre always changes it to 04/11/12. Any ideas here?A: As for your first question, that's probably an issue of formatting. A lot of times people will just add data into cells when the entire column of cells is formatted to a specific alignment. You can change the alignment of one or more of those cells, but it doesn't change the format of the entire column. If you click the Column header (above the very top cell - it will be labeled with a letter) to select the entire column and then you set the alignment, that alignment shouldn't change. If it does, there could be an issue with your template or even a conditional formatting.
Regarding the second portion of your question, you need to set the default date format in Calc. To do this click Tools | Options and then expand the LibreOffice Calc section. Within this newly expanded section, you will see a listing for Calculate. Click that entry, and then select which default date format you want.Ask Jack: If you have a DIY question, email it to me, and I'll do my best to answer it. (Read guidelines about submitting DIY questions.)
Also read on TechRepublic
Jack Wallen is an award-winning writer for Techrepublic and Linux.com. As an avid promoter/user of the Linux OS, Jack tries to convert as many users to open source as possible. His current favorite flavor of Linux is Bodhi Linux (a melding of Ubuntu and Enlightenment). When Jack isn't writing about Linux he is hard at work on his other writing career -- writing about zombies, various killers, super heroes, and just about everything else he can manipulate between the folds of reality. You can find Jack's books on Amazon, Barnes & Noble, and Smashwords. Outnumbered in his house one male to two females and three humans to six felines, Jack maintains his sanity by riding his mountain bike and working on his next books. For more news about Jack Wallen, visit his website Get Jack'd.