How to custom a column? | Infragistics Forums

State See Verified Answer
Replies 3 replies
Subscribers 6 subscribers
Views 976249 views
Users 0 members are here

XamSpreadsheet

315

How to custom a column?

Linden Johnson posted over 10 years ago

How can I custom a column? Column A, for example:

1. Change heading from "A" to "Mac Address"
2. Define the column NumberFormat, a 32bit integer,
it can be modifed and displayed in "255.255.255.1" text format.

Thank you.

138253

Verified Answer
Offline Stefan posted over 10 years ago in reply to Linden Johnson

Hello Linden,

If you set the FormatString to 000"."000"."000"."0 the numbers in the cells will be formatted as you want.
Cancel
Reply

Reject Answer

Cancel
315

Linden Johnson posted over 10 years ago in reply to Stefan

If just pure text, it's simple.

wb.Worksheets[0].Columns[0].CellFormat.FormatString = "??#.??#.??#.??#";

But I want the cell is a number background, just display and edit in 255.255.255.2 format.

Just FormatString property can do this? If so, could you please give me an example?

If a cell can be set as masked input or regex input, it's fine, does XamSpreadsheet support?

Thank you.
Cancel
Reply

Cancel
138253

Offline Stefan posted over 10 years ago
Hello Linden,

After looking into this and doing some research, "Change heading" has been determined to be a new product idea. You can suggest new product ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.

There are many benefits to submitting an product idea:

-          Direct communication with our product management team regarding your product idea.

-          Notifications whenever new information regarding your idea becomes available.

-          Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.

-          Allow you to shape the future of our products by requesting new controls and products altogether.

-          You and other developers can discuss existing product ideas with members of our Product Management team.

Steps to create your idea:

Log into the Infragistics Product Idea site at http://ideas.infragistics.com (creating a new login if needed).

Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)

Add your product idea and be sure to be specific and provide as much detail as possible. Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!

“Include a link to this thread” in your idea so product management will be able to look back at this case.

The Product Idea site puts you in the driver’s seat and allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.

As for the formatting, you can either change the format in the excel you load or you can use the Workbook class and access a specific column like this:

Workbook wb = Workbook.Load("myExcelfile.xlsx"); wb.Worksheets[0].Columns[0].CellFormat.FormatString = "my format";

and set its FormatString Property.

Thank you for contacting Infragistics.
Cancel
Reply

Cancel