Duplicate Cell properties automatically in Quattro Pro - Documentation - WordPerfect Office - OfficeCommunity.com
  • Not Answered

Duplicate Cell properties automatically in Quattro Pro

Hello

Normally I work through challenges myself and learn as I go, but at the moment, time is in a crunch so I am in need to do a bit of brain picking to see my current project through in the fast lane.

I am fairly new to Quattro Pro and just bumping around using what I know from Open Office and Excel 97.

My current task at hand is:
I have multiple sheets, For sake of example, SheetA will be a master all other sheets contain parts (various cell content) from the master. This is not an problem, but what I am looking to do is not only duplicate cell content, but also cell properties. In other words, if I change cell "master:A2" to red with white text I would want the targeted cell "page2:B4" to also change to red with white text.

Seems it should be simple enough...

Thank you

Nelson

19 Replies

  • In reply to Nelson:

    No problems. I ran out of time last night to do the detailed work.

    A revised Residents.qpw file has been uploaded at the same URL as before. It adds a macro (C31..C50) that illustrates how to put the data and coloration into particular cells on the resident card, as detailed in C29, which you can of course vary. The "Generate Resident Card" button was set to run this new macro.

    After the preliminaries (C31..C32), when the macro navigates to the target cell on the resident card and determines the source cell on the master sheet, it runs the macro at H35..H39 to put the cell contents and coloration into the currently active cell. Commentary appears in column A.

    Charlie
  • In reply to Charles Cork:

    I am running into one limitation and wondering if there are any work arounds?? Seems I can not wrap text in a rotated cell.
    I have sections of a sheet that displays text in both right side up and upside down so it can be viewed from both sides. Before I redesign this area of the template sheet, I would want to explore a work around to keep my current template if possible.
    Thank you
    Nelson
  • In reply to Nelson:

    I never tried that before, but rotating text seems to gray out the wrap-text option on selection properties, so they are probably incompatible as designed.

    A workaround might be to have a second cell for rotated text next to the current one(s), and devise the macro that fills them (1) to find a suitable space in the source text, (2) put text to the left of that space into one cell, (3) put text to the right of that space into the other cell.

    For instance, you might start with a formula that finds the first space after, say, the 20th character, and use that as the dividing point: e.g.: @Find(" ",A1,20), if the source text is in cell A1. An @left function would then get text to the left of it {e.g., @left(A1,@Find(" ",A1,20))}, and @right would get text to the right of it, with @trim eliminating unnecessary spaces {e.g., @trim(@right(A1,@Find(" ",A1,20)))}. Through trial and error, the number 20 could be adjusted to fit your typical text, though no method would be infallible.

    Charlie
  • In reply to Charles Cork:

    I think it will be simpler for to redesign the center part of the Res* sheets where I have the 2 blocks side by side (one normal and other rotated) and place them on to of each other to keep contents in a single line. Since the number of instances where this box would need to wrap is very small I think the breaking into 2 cells would not be very clean for the 99% that would not need it.

    Then maybe Corel is also monitoring this community and see this limitation discussion and put a fix into an update:-) Wishful thinking anyway.

    I will work around this as a simpler fix

    Thanks
    Nelson