MS Office woes

-

Change the separator in all .csv text files

##########################################################################
In Microsoft Windows, click the Start button, and then click Control Panel.
Open the Regional and Language Options dialog box.
Do one of the following:
In Windows Vista, click the Formats tab, and then click Customize this format.
In Windows XP, click the Regional Options tab, and then click Customize.
Type a new separator in the List separator box.
Click OK twice.
 NOTE   After you change the list separator character for your computer, all programs use the new character as a list separator. You can change the character back to the default character by following the same procedure.


##########################################################################

','(comma ) is used as Separator for CSV file; regardless of 'List Separator' Setting in Control Panel. 

##########################################################################
SYMPTOMS
When you save your file as a Comma Separated Value (CSV) file from Excel, the s...
When you save your file as a Comma Separated Value (CSV) file from Excel, the separator (delimiter) that is used is not the character that you chose to be the List separator for your system. When this occurs, you do not receive a warning or error message.

CAUSE
You chose the same character for both your Decimal symbol and your List separat...
You chose the same character for both your Decimal symbol and your List separator in the Regional Settings of your system Control Panel . In this condition, Excel must substitute another character for the list separator to avoid a possible loss of information when the CSV file is saved.

WORKAROUND
Change either your List separator or your Decimal symbol in the Regional Settin...
Change either your List separator or your Decimal symbol in the Regional Settings , so that they are not the same character. To do this, follow these steps:
Click Start , point to Settings , and then click Control Panel .
Double-click Regional Settings or Regional Options . Click the Number (or Numbers ) tab.
In the Decimal symbols list, choose a character that is not the same as your list separator. Alternately, in the List separator list, choose a character that is not the same as your decimal symbol.
Click OK .
If you are prompted to restart the computer, do so.

##########################################################################

Comments

  1. Vaibhav DalviMay 9, 2012 at 12:56 PM

    Well, MS Excel generates same csv as openOffice; I am going to check my csv import script; something might be broken there.

    ReplyDelete

Post a Comment

Popular posts from this blog

Morning Quotes

-
Image
Source: www.brainyquote.com   I may be drunk, Miss, but in the morning I will be sober and you will still be ugly. Winston Churchill   Prayer is the key of the morning and the bolt of the evening. Mohandas Gandhi   I look upon death to be as necessary to our constitution as sleep. We shall rise refreshed in the morning. Benjamin Franklin  
Read more

QCalendarWidget CSS Stylesheeting

-
Recently I had to implement a calendar for a TouchScreen application. I resorted to css to modify the calendar widget's appearance so that it would be more accessible. Following is the code that enabled me to get a proper calendar. calendar->setStyleSheet("QMenu { font-size:20px; width: 300px; left: 20px; }"     "QToolButton {icon-size: 48px, 48px; font: 20px; height: 70px; width: 100px; }"     "QAbstractItemView {selection-background-color: rgb(255, 174, 0);}"     "QToolButton::menu-indicator{ width: 50px;}"     "QToolButton::menu-indicator:pressed,"     "QToolButton::menu-indicator:open{ top:10px; left: 10px;}"     "QTableView { font: 30px; }"     "QSpinBox { width: 100px; font: 20px;}"     "QSpinBox::up-button { width:40px;}"     "QSpinBox::down-button { width:40px;}");
Read more