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
