On Wed, 16 Jul 2008, mjw_85uk wrote:
At the moment all i want to do is display a message when the cell styles match. However, this never happens. Before i clone the style the field_1_font_index of oldStyle is 20 but when this is cloned the field_1_font_index of newStyle is changed to 5 therefore i the oldstyle and newstyle will never be the same. What is causing the field_1 to change from 20 to 5 when it is cloned?
In the old workbook, you have 20 odd fonts. In the new one, you have 5. So, the index of a particular font is going to be different
Your hashtable should be key=old style, value=new style. If a given old style doesn't exist in the hash, create a new style and clone onto it. Then, when copying cells, ask the hash to give you the matching new style
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
