First of all in my Regional and language options Decimal symbol is comma "," and Digit grouping symbol is dot ".". If Decimal symbol is dot "." and grouping
symbol space " " then it's okay. But i must use:
Decimal symbol comma "," and Digit grouping symbol dot ".". I will try to reproduce steps how to find this bug, but we need to apply Regional and language settings before we begin. After that:
1. Open new workbook, select some cell and press few times "Del" button on the right side of keyboard where are numbers(if we use main button separator near the letter keyboard it's ok). As result we have to see our comma in cell.
2. Open VBA editor, and create new module, write this code and of course launch this sub:
Sub Example
ActiveSheet.PrintPreview
End Sub
3. Now we see PrintPreview with our written comma, so press Print or Ctrl+P, and wait until it will send to printer and back to our Sheet. By the way Printer can be offline it's no matter.
4. Select other cell and press "Del" button on the right side of keyboard where are numbers. And as you see now our "Del" writing not comma but dot... so after printing our separator changed.
5. If we will launch our sub example again, our separator will change back from dot to comma.. and so on.
I have tried:
1 .
Excel options -> Advanced -> "Use System separators" Uncheck(because as default it's checked) and after with Checked.
2. Tried on other OS like Windows XP, VISTA, Win7 - all updates (3 different PC)
3. Even in other Excel versions 2003, 2007, 2010 - all updates (3 different PC)
4. With other printers Cannon, Samsung, HP..
Maybe I'm doing something wrong? Any ideas?