AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25 - Calc in use on a WIN10-64 desktop.
I would like to register/link/embed a file on my computer that serves as
a reminder of the colors that I should use within a particular Calc
workbook, as shown below. There is a high likelihood that additional
"reminder" entries will occur sometime in the future, so I think a
centrally registered, stored AOO Writer file, which shall be revised as
needed, is desired for this purpose.
At present I have the reminders present on each Calc sheet in my
spreadsheet file. This is problematic, because it is somewhat difficult
to paste the info when considering the width of the column and the
likelihood that additional reminder entries are potentially needed.
I tried using copy-paste into a "comment" box, but the color shadings
are not shown when displaying the comment in Calc; i.e., the color
shading is required. I suspect that an "object" file must be inserted;
however, I am not experienced in that Calc feature at present.
Can anyone suggest a method that I might use such that I can optionally
display my "registered reminders" (see below), perhaps as a popup on
screen while I am at the same time viewing the Calc sheet presently
being worked on? Is it possible to "split" the displayed screen such
that Sheet 1 is on the left and Sheet 2 is on the right? I need to see
both the reminders and the present worksheet on the screen at the same
COLOR CODING USED ON THIS SHEET
GRAY 1: Shaded box area for filled-in form.
GRAY 3: Calculated (locally) value result.
GREEN 3: Values swiped from another sheet.
CHART 1:Values swiped from another document/sheet.
YELLOW: Values filled-in manually by operator.