Dimitry at Gallery Systems
created the CR attached, which produces an illustrated checklist that can be
saved in Excel, as a PDF, or in Word; it doesn’t sort (at least not for me).
Laura
Laura Coyle
Collection Manager
Smithsonian National Museum of
African American History and Culture
600 Maryland Avenue, SW Suite
7001
Mail: MRC 509 PO Box 37012
Washington, DC 20013-7012
Telephone: 202.633.0249
Fax: 202.633.4816
Email: [log in to unmask]
Web: nmaahc.si.edu
From: The Museum System
(TMS) Users [mailto:[log in to unmask]] On Behalf Of Kate
Blanch
Sent: Friday, March 25, 2011 1:39 PM
To: [log in to unmask]
Subject: Checklists and Sorting Images in Excel
Hi all - This is more an Office conundrum than TMS question
but since I know we all appreciate a good checklist…
I’ve created a custom Crystal report in TMS that is a
checklist. I have gotten the data and the ThumbBLOB (thumbnail) to export to
Excel while maintaining the integrity of the grid (no extra columns, blank rows
or alignment issues occur). The issue is that when sorting the Excel spreadsheet
– the images don’t sort with their associated rows. The data sorts great.
Everyone here seems to have a different wives tale as to how
to make the images sort with the cells and none work consistently…do you all
have any tricks that could inform this issue? Ideally the solution would be
some formatting thing we could apply to the whole worksheet (and not have to
adjust each image’s properties, individually).
Thanks in advance and have a super weekend!
Kate Blanch
Administrator, Museum Databases
[log in to unmask]
/ 410.547.9000 ext. 266
The Walters Art Museum
600 N. Charles Street, Baltimore MD 21201
Treasures of Heaven: Saints, Relics and Devotion in
Medieval Europe February 13–May 15, 2011
Realistic Perfection: The Making of Oriental
Ceramic Art March 12–June 4,
2011
Relics and Reliquaries: Reconsidered February
26–May 22, 2011
To
unsubscribe, send an email to [log in to unmask]
with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.