Spreadsheet background image
-
@dustinb3403 said in Spreadsheet background image:
Adding text is as simple as it possible can be, you click the T icon, and click where you want it. Type whatever, and then you can move it around if you don't like the exact placement.
I see what your saying but that's two extra steps, click the cell and just typing would be quicker
-
@hobbit666 said in Spreadsheet background image:
@gjacobse said in Spreadsheet background image:
How often do you need to do this?
Not often at the moment, it's only really for diagnosis of boards when I need help
Just thought it would be a nice way of putting the data on to share.Try ShareX (It is Windows Only though) but it works amazingly well. Best screenshot tool I've used and has a ton of functionality without the complexity.
The only thing I do at install is disable the "Uploading" of images (which it asks the first time anyways).
-
@dustinb3403 I use greenshot but will give that a go tomorrow
-
-
This is using WORD - took a moment to sort but MAY be close to what you are trying to do.
Add image to Word, then set to BEHIND TEXT, then Using WORD Tools to add pointer, and the single row three column table.
-
@gjacobse said in Spreadsheet background image:
This is using WORD - took a moment to sort but MAY be close to what you are trying to do.
Define "a moment"
-
@dustinb3403 said in Spreadsheet background image:
@gjacobse said in Spreadsheet background image:
This is using WORD - took a moment to sort but MAY be close to what you are trying to do.
Define "a moment"
about two minutes or so after about 30 minutes sorta trying to remember how I did similar about five years ago.
-
@gjacobse So 32 minutes give or take...
-
@dustinb3403 said in Spreadsheet background image:
@gjacobse So 32 minutes give or take...
Minus time reading another document, saving some addresses to a text file, changing channels on Pandora...
-
@dustinb3403 said in Spreadsheet background image:
@gjacobse So 32 minutes give or take...
I'd say that's probably the average to use a image in a word document so it doesn't look like shit.
That's per image. Imagine adding 5 images and trying to get them to align properly with text
-
@irj yea that was my thought process as well.
Where as using an image creator/editor to do it, namely ShareX is a matter of seconds per image.
-
@hobbit666 said in Spreadsheet background image:
@dustinb3403 said in Spreadsheet background image:
I'm assuming you're wanting to add notes, based on the yellow arrows.
/assuming
Nope I need to put in reading for all the coloured lines and arrows
hence not wanting to have to manual add text boxes all over the place.
But it's looking like that's the only way.The idea of the excel was I could just click in the cell easily and just type the values
I can't really envision what you wanted to do with excel...
-
@hobbit666 have you tried printing out the image and using as bright sharpie?
-
@dashrender said in Spreadsheet background image:
@hobbit666 said in Spreadsheet background image:
@dustinb3403 said in Spreadsheet background image:
I'm assuming you're wanting to add notes, based on the yellow arrows.
/assuming
Nope I need to put in reading for all the coloured lines and arrows
hence not wanting to have to manual add text boxes all over the place.
But it's looking like that's the only way.The idea of the excel was I could just click in the cell easily and just type the values
I can't really envision what you wanted to do with excel...
I thought what he wanted to do was pretty well explained in the quote, but there isn't any good way to ensure the cells align with the image.
-
@dustinb3403 said in Spreadsheet background image:
@dashrender said in Spreadsheet background image:
@hobbit666 said in Spreadsheet background image:
@dustinb3403 said in Spreadsheet background image:
I'm assuming you're wanting to add notes, based on the yellow arrows.
/assuming
Nope I need to put in reading for all the coloured lines and arrows
hence not wanting to have to manual add text boxes all over the place.
But it's looking like that's the only way.The idea of the excel was I could just click in the cell easily and just type the values
I can't really envision what you wanted to do with excel...
I thought what he wanted to do was pretty well explained in the quote, but there isn't any good way to ensure the cells align with the image.
The parts aren't in a grid fashion, unless you make the grid super tiny, then you just have a mess
-
@hobbit666 said in Spreadsheet background image:
Need some help.
I've got an image that I need to write several values on, enough for me not wanting to do it in paint or other image tool and create box boxes etc.So I thought if I can add the image onto a spread sheet I can just write my values in the cells easy.
Well I can't get the image to add "under" the cells.
Any advice? I'm using Excel but happy to use anything, like OpenOffice etc
If I add the image as a background image it repeats itself.
If I add as a image it goes on top of the cells
This is an example of the image
Page Layout -> Background
-
@dashrender said in Spreadsheet background image:
@dustinb3403 said in Spreadsheet background image:
@dashrender said in Spreadsheet background image:
@hobbit666 said in Spreadsheet background image:
@dustinb3403 said in Spreadsheet background image:
I'm assuming you're wanting to add notes, based on the yellow arrows.
/assuming
Nope I need to put in reading for all the coloured lines and arrows
hence not wanting to have to manual add text boxes all over the place.
But it's looking like that's the only way.The idea of the excel was I could just click in the cell easily and just type the values
I can't really envision what you wanted to do with excel...
I thought what he wanted to do was pretty well explained in the quote, but there isn't any good way to ensure the cells align with the image.
The parts aren't in a grid fashion, unless you make the grid super tiny, then you just have a mess
Sure, but that is doable. So are many things, doesn't mean you want to do em...
-
This is the type of work that is easiest accomplish with a vector graphics design software.
A free open source solution easily available would be LibreOffice/OpenOffice Draw.
You could save the result in whatever format you want - pdf, tiff, png, jpeg etc.
-
Yeah i'm just copying the image to a new file and using gimp to add the values where i need them
Guess i'll get quicker at it the more i do it.
