A parts list with images using Libreoffice and a Macro

Thread Starter


Joined Oct 23, 2018
Ref this thread: https://www.reddit.com/r/electronics/comments/7whw33
I'm trying to create an updated parts list for newbies with suitable images using Libreoffice-Calc and Macros. My spreadsheet is here: https://docs.google.com/spreadsheets/d/1Ps4ddtlPiAdY6rlaXH2Izs-M8Gm3GfkGEQHGyOQYyjI/edit?usp=sharing Macro code is below.

The OP has not disclosed the source for his parts description/text so it's difficult for me to locate unambiguous images for the various parts.

  1. Could someone suggest how I might use his descriptions to locate suitable images. I tried google but it throws up more ambiguity: if I google 'Ring, in-line, 22~18AWG, red insulation' I get but I also get The OP himself was not particularly helpful in PM.
  2. Any suggestions on better presentation - fonts, highlighting of parameters
  3. Any updates to the OPs parts list.
(note the images that I have anchored to the cell and the arrowheads that denote where It's ambiguous to me..) I need to figure that out.. suggestions?

Macro code https://pastebin.com/kNVQg39T
Last edited: