In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
Solved
VSTO 2005 Storing format details as strings
Posted on 2006-11-20
Hi
How do you store the formatting details of a
formatted cell in a managed spreadsheet?
eg the I need the color to be stored as a string variable for later use
How do you store the formatting details of a
formatted cell in a managed spreadsheet?
eg the I need the color to be stored as a string variable for later use
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
does this work?
' Work with the current active cell.
Dim currentCell As Excel.Range = Me.Application.ActiveCell
'create a style on thw workbook
Dim style As Excel.Style = Globals.ThisWorkbook.Style
'assign the style of cell to the style created
style = currentCell.Style
now you can reference the "style" on any other cell.
from another part in code
' Work with the current active cell.
Dim currentCell As Excel.Range = Me.Application.ActiveCell
currentCell.Style = "NewStyle"
' Work with the current active cell.
Dim currentCell As Excel.Range = Me.Application.ActiveCell
'create a style on thw workbook
Dim style As Excel.Style = Globals.ThisWorkbook.Style
'assign the style of cell to the style created
style = currentCell.Style
now you can reference the "style" on any other cell.
from another part in code
' Work with the current active cell.
Dim currentCell As Excel.Range = Me.Application.ActiveCell
currentCell.Style = "NewStyle"
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place!
Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Introduction
When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month6 days, 7 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.