[users] Hi I need the various Formatting to be returned after a CONCATENATE

2005-05-11 Thread Warwick Taylor
Hi I require that the Formatting from the originating cell to be the format for that particular portion of the resultant cell after a CONCATENATE of a several cells in an OO1.0 spreadsheet. I am drawing up a phone book and require that, in particular, that the Surname & the First Names retain the

Re: [users] Hi I need the various Formatting to be returned after a CONCATENATE

2005-05-11 Thread Paul
I agree it does not work. Potentially this is because there does not seem to be character styles for calc. Interesting to see if enhancement is worked on. /paul On 5/11/05, Warwick Taylor <[EMAIL PROTECTED]> wrote: > Hi > I require that the Formatting from the originating cell to be the > form

Re: [users] Hi I need the various Formatting to be returned after a CONCATENATE

2005-05-12 Thread Paul
I'm sure there would be a way to have a macro trawl through a column and apply a font/size/attribute change to a particular part of the cell. To make it easier you would probably be best to have some identifier that could be searched in the cell to delineate the area. eg, Using - "Smith, Bob : 12