Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Prevent Format changes between Appl's. (Excel 2002)

    Hi,
    I know this is a strange request, but I'll never know if there is a useful response to this question if I do not ask it!

    Is there a way to prevent format changes (eg, shading colours) from changing when you copy and paste between external DB appl's like SAP or SQL Server?
    These DB reports are formatted with nice shadings, but the moment its copied to Excel, the colours (shadings) go to these horrid colours.!!!! <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Prevent Format changes between Appl's. (Excel 2002)

    I doubt it. An Excel workbook has a color palette consisting of 56 colors. Although this palette can be modified, I don't know of a way to make the palette adjust itself automatically to data pasted in from other applications.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Prevent Format changes between Appl's. (Excel 2002)

    Rudi

    This was a very old post that was sent on my behalf by an old colleague <!post=Custom Color Pallettes,113079 >Custom Color Pallettes<!/post> , Cindy was the lady who introduced me into the world of Woodys <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> to Cindy.

    It uses a template that you can customise... this may give you some ideas.
    Jerry

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Prevent Format changes between Appl's. (Excel 2002)

    Thanks Jezza and Hans

    PS: Can I just confirm.... If I create a new template with this customised colour palette, (as <post#=113153>post 113153</post#> specifies; Will the psted DB data automatically take on the new colour scheme!

    For example. I paste the DB data into a new W?B. The colours are horrid! So I edit the colours to look better using some modified colours in the colour palette. I then clean out the sheet, save the W?B as a new template. When I open a copy of the template (with the new colour palette) and paste the DB data into it, will the colours immediately take on the colour scheme of the new palette?

    Sorry for all the Q's!!
    Cheers
    Regards,
    Rudi

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Prevent Format changes between Appl's. (Excel 2002)

    Yes, data pasted into an Excel workbook with a customized palette should use the colors from that palette.

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Prevent Format changes between Appl's. (Excel 2002)

    Cheers then, Jezz and Hans. This may then be a workaround solution to my problem.
    Tx
    Regards,
    Rudi

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Prevent Format changes between Appl's. (Excel 2002)

    Confirming HansV

    It uses the custom pallette, tried and tested this end for a project and it does not affect other books which was Legares concern as long as it is in its own XLT and not placed in XLStart
    Jerry

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Prevent Format changes between Appl's. (Excel 2002)

    Thanks Jezza.
    Much appreciated!
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •