?

Log in

No account? Create an account
 
 
06 February 2008 @ 12:04 pm
IT people? Help?  
I have a question for the computer minded among you who use Excel. Even though it's evil.

The picture below is a screencap of the document I'm working with. I copy/pasted the info from a website which is chock full of back/forward buttons. I selected the sheet, cleared the formating in all cells and did a bunch of sorting and other things. Now... if you open the screencap (it'll open in a new window/tab) you can see the little blue arrows. They aint in a cell. I need to be able to get rid of 'em.

Anyone know how I can salt and burn 'em?

(I've tried inserting a row, moving the contents of the cells to the new row and deleting the pre-existing row but all it did was move the arrows down a little...

Help?








ETA So I have no idea how or why, but it seems to have been fixed. I selected the entire sheet, copied it (intending to paste into a text editor and save as a .tsv (tab-delimited) file so I could import it back into Excel) and thought I'd try pasting it into a new worksheet. It only pasted in the data I wanted and all the weird graphics have stayed on the first sheet. Excel is ev0l I tells ya!

Thank you all so much for your help and advice! Now wish me luck for the rest of the afternoon when I have to track down 1324 URLs and check the holdings dates are accurate. No really, I love my job...
 
 
Current Mood: frustratedfrustrated
 
 
 
Jackiewillowmina on February 6th, 2008 12:16 pm (UTC)
Don't have Excel on this computer - but it's not anything switched on in Tracking Changes or anything... I know in Word you can get all sorts of odd things that will disappear if you turn off the Tracking...

Only other thing I can think of is it's something to do with sorting...

Will e-mail Ben the link - he uses Excel everyday - he might be able to come up with something...
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 12:19 pm (UTC)
Cheers Jackie - I just noticed something else as well, four rows up from the arrows is another graphic - a slight curve. I'm guessing these were pasted over from the website I took the data from?
Jackiewillowmina on February 6th, 2008 12:44 pm (UTC)
Ben says that yes - they do look like graphics - do they move to different cells... or no...?
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 12:45 pm (UTC)
Nope, they seem to just be randomly floating over the top of everything else
Jackiewillowmina on February 6th, 2008 12:56 pm (UTC)
Alas - Ben's only suggestion is to re-copy the data...
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 12:57 pm (UTC)
Ah well, thanks anyway! There's been a lot of work done to the data already so I'm hopeful that I can work around it if I have to.

Thank Ben for me too!
Jackiewillowmina on February 6th, 2008 12:59 pm (UTC)
Shall do...
Ah yes, quite a bunch of us, isn't it?unhobbityhobbit on February 6th, 2008 12:24 pm (UTC)
My eyes glazed over. I think I've lost the ability to look at excel spreadsheets, my brain just switches into 'bored'.

Hardly a great loss to you, because I couldn't help you with your problem at any rate.
the girl who used to dance on fire and brimstone: head-desk - mewhiskyinmind on February 6th, 2008 12:34 pm (UTC)
*grins*

and this is quite a straightforward one as well. Just wait till I split the dates in the last column into two new columns and then add the URLs. Then my eyes will do the glazing over thing...
Ah yes, quite a bunch of us, isn't it?unhobbityhobbit on February 6th, 2008 12:40 pm (UTC)
I... no... no, my brain refuses to understand that second sentence. It could if it tried, but it's too much effort to stop my eyes skipping over it.

My brain wishes your brain good luck.
The Great and Terrible Oz: Can't Stop Being A Robotludditerobot on February 6th, 2008 12:33 pm (UTC)
The quick and easy way would be to copy it again, paste it into Notepad or some other text editor and copy from that. That should remove the ickies.
the girl who used to dance on fire and brimstone: Pratchett//redo from start - wildecatewhiskyinmind on February 6th, 2008 12:36 pm (UTC)
When you say copy again, do you mean from the spreadsheet I have or from the original site? Because I've already done a lot of work on the sheet that would be lost if I re-copied fromt he site.

I can kinda live with the graphics over the top if I have to but it's irritating.
The Great and Terrible Oz: Can't Stop Being A Robotludditerobot on February 6th, 2008 12:39 pm (UTC)
I was thinking from original site, but I get your reticence.

OK, try this: Export as CSV and re-open the CSV. Images should not survive the textiness of Comma-Separated Valueism.

And if you can wait a couple hours, I can help you more from work.
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 12:43 pm (UTC)
Can I export as .tsv instead? There's commas interspersed in the text fields which will screw up the .csv export.
The Great and Terrible Ozludditerobot on February 6th, 2008 12:46 pm (UTC)
We say "tab delimited" in the field, but yeah. I forget the proper mojo to do so, but it's out there.
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 01:05 pm (UTC)
Cheers for your help! It's fixed now, not entirely sure how but so lonf as it's done that's the main thing!
The Great and Terrible Oz: Can't Stop Being A Robotludditerobot on February 6th, 2008 01:09 pm (UTC)
Think of it as hiding from a bad date in the ladies' room. The guy can't follow you there. The icky image objects cannot live in a pure text world.
the girl who used to dance on fire and brimstone: spn//adrianne laugh - mewhiskyinmind on February 6th, 2008 01:11 pm (UTC)
Ha! Nice analogy!
(Deleted comment)
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 12:38 pm (UTC)
Nope, Monkey tried to right click it and nothing. It's like there's another layer overlaying the whole sheet with the graphics on it.
Ah yes, quite a bunch of us, isn't it?unhobbityhobbit on February 6th, 2008 12:41 pm (UTC)
Perhaps you're in Photoshop.
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 12:42 pm (UTC)
*grins*

see it's my Photoshop brain that made the layers connection. I don't think there are layers in Excel. Because it's ev0l.
(Deleted comment)
the girl who used to dance on fire and brimstone: Pratchett//redo from start - wildecatewhiskyinmind on February 6th, 2008 12:45 pm (UTC)
Not so far as I can see. I unchecked and checked things to see if it helped but nothing.

It's an evil conspiracy...
(Deleted comment)
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 01:04 pm (UTC)
*points up to the comment I made to LudditeRobot*

There's commas dotted throughout the text entries...

But it's all good now - I fixed it. I have no idea how I fixed it, but I fixed it!
Jackiewillowmina on February 6th, 2008 12:59 pm (UTC)
On that tack - have you tried using the drawing toolbar arrow to draw a huge box over the screen... It might highlight it so you can delete....
the girl who used to dance on fire and brimstonewhiskyinmind on February 6th, 2008 01:06 pm (UTC)
It seems to be sorted out now - still a complete mystery as to how it happened or how it fixed, but the arrows are gone now so that's the main thing!
draconin: coffeedraconin on February 6th, 2008 02:38 pm (UTC)
I suspect that the objects you're seeing are command buttons. If you use Excel at the programming level then you can put buttons and so on onto the screen so that they float above the grid, optionally moving with cells or not. You then attach either a macro or a Visual Basic subroutine to them and when the user clicks on them the attached code gets executed. The image on the right is of a spreadsheet I created to use as a marksbook. Each button runs a whole slew of code.

When Excel imported the data from the web page it must have decided that a command button was the closest thing it had to an image/object on the web that was clickable and that did something when you clicked on it.

If that's what they are then the way to get rid of them is easy. Make sure the sheet is not protected and then hold down the Ctrl key on the keyboard before you click on them. You should find that the button will be selected and you can then just press delete.

If that doesn't work I'm not sure what the solution is. I'm happy to have a look if you send the file to me. I use Excel a lot. :-)

Edited at 2008-02-06 02:40 pm (UTC)
the girl who used to dance on fire and brimstone: Pratchett//redo from start - wildecatewhiskyinmind on February 7th, 2008 10:36 am (UTC)
Oooo - now that sounds likely to be what it was! I've managed to get it sorted this time, but I have to use that site a lot so I might just take you up on it if it happens again.

Cheers!