Top "Cell-formatting" questions

Inserting value into Excel cell instead of formula

I have a VBA script that inserts long strings into Excel cells. In some cases, the string begins with a =. …

excel vba cell-formatting
How to format cells in excel to enter 24-hour time?

When I enter a value as 13.25, the value should be changed as 13:25 and not 06:00. How to format the cell for …

excel time-format cell-formatting
NPOI create cell containing bold and non bold text

I'm using NPOI to output excel from Asp.Net MVC app and works very well with plain text but have …

c# npoi cell-formatting
How to format radgrid cell programmatically

I have to format (backcolor, forecolor, font style) a radgrid's cells depending on the value of the cell. For example …

telerik radgrid cell-formatting
Change number group separator in numeric columns of DataGridView

I want to format cells that are numeric in this way 1 231 241.45. I've tried N2 format option: datagridview1.Columns["col1"].DefaultCellStyle.…

c# .net winforms datagridview cell-formatting
How to pre-format a cell to date on Laravel Excel

I am using the package maatwebsite.com/excel for exporting xls files from my app. I want to pre-format the …

php excel laravel cell-formatting laravel-excel
How to set Excel cell format in iReport

I'm trying to export a report as xls, but when i open my exported file i notice that all cell …

export-to-excel ireport cell-formatting
Set openpyxl cell format to currency

I'm creating an excel sheet using openpyxl. Some cells represent monetary values. How can I change the format of a …

python excel currency openpyxl cell-formatting
How can you format the result of a formula as s number

I'm using a formula in Excel 2007 to grab a mailbox size from a string. I'm stripping out all of the …

excel-2007 cell-formatting
Export the dataGridView to Excel with all the cells format

I have this code that I know that it works fast CopyAlltoClipboard(dataGridViewControl); Microsoft.Office.Interop.Excel.Application xlexcel; Microsoft.…

c# .net datagridview excel-interop cell-formatting