TABULUS®, The Table Oriented Spreadsheet

TABULUS® 2010 - Simply put, TABULUS is a better spreadsheet!

TABULUS® 2010 FREE Trial
home recent topics recent posts search faq

TABULUS® Forums
Messages in this topic - RSS

Home » Bug Reports » Copy and Paste From Excel Changes Magnitude

|
1/25/2010 8:26:09 AM

seanflaher
seanflaher
Posts: 38 		With the first release build, I'm seeing a new problem with copy and paste. If I create an Excel spreadsheet (I'm using 2003) and set a cell to "180000". If I copy and paste that into a Tabulus cell, it pastes as "180". I'm using the "Basic P&L" template for my testing in Tabulus. This worked fine in the final beta.
permalink
1/25/2010 9:50:33 AM

rado
rado
Posts: 47 		We reproduced the bug and logged it as case 4390. The problem can be reproduced if you have US regional settings where thousand and list separators are the same (comma). When you type 180,000 the program treats it as two numbers. The fix will be added to the next program update. Possible workarround - change list separator to semicolon instead of comma in regional settings. However if you copy more than one cell the problem does not persist.

--
Radoslav Nemchev
CTO, Diehl Technology LLC
permalink
1/25/2010 11:27:17 AM

seanflaher
seanflaher
Posts: 38 		Thanks for the quick answer. I couldn't figure out how to "change list separator to semicolon" for pasting. I tried changing the thousands separator to "none" in both File->Options and Tools->Options but neither had any effect on pasting.

I am also seeing this when I paste more than one cell, it doesn't seem to matter if it is more than one or not.
permalink
1/25/2010 11:37:27 AM

rado
rado
Posts: 47 		You can change list separator using Windows Control Panel. Double click on "Regional and Language Options" icon. In the shown dialog verify that English (United States) format is chosen and click on "Customize this format" button. In "List Separator" combo enter semi-colon (there is comma by default) and press OK button.
edited by rado on 1/25/2010

--
Radoslav Nemchev
CTO, Diehl Technology LLC
permalink
1/25/2010 1:10:21 PM

seanflaher
seanflaher
Posts: 38 		Great! That will save me a lot of time retyping numbers...
permalink
4/20/2010 9:25:29 AM

rado
rado
Posts: 47 		The bug is fixed in TABULUS 2010 SP1.

--
Radoslav Nemchev
CTO, Diehl Technology LLC
permalink
pages: 1
|

Home » Bug Reports » Copy and Paste From Excel Changes Magnitude