| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retain cell formatting?
When we are setting the value of a cell we are losing formatting €“ is there
anyway we can retain the cell formatting r.set_Value(Excel1.XlRangeValueDataType.xlRangeVal ueDefault, factValue); // factValue is string r.Cells.NumberFormat = Thread.CurrentThread.CurrentCulture.NumberFormat.N umberDecimalSeparator ; Is there anything else needs to be done ? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I retain cell formatting when I export from Crystal Reports 11into a .xls file? | Excel Discussion (Misc queries) | |||
| copy/paste want to retain cell coloration but lose the conditional formatting source data | Excel Discussion (Misc queries) | |||
| retain cell formatting | Excel Discussion (Misc queries) | |||
| Retain cell number formatting in Word Mail Merge | Excel Programming | |||
| Increase / decrease decimal - retain cell formatting | Excel Programming | |||
Threaded Mode
