Posting spreadsheet test

[Rick Hufnagel]

Just Rick's watch Co Observations

Just Rick Watch Co Observations hello,just,trying to,figure,out if,i,can add,my,spreadsheet to,a,thread John,Matthews,was I wonder if it,updates the ,xls sheet

docs.google.com

Let's see if it works

 

[Rick Hufnagel]

Hey, if anyone reads this, try to click on the spreadsheet and change some fields. Let me know if you can or can not change something in the file. Please!

I guess you have to have a Google account to see the sheet?

 

[Rick Hufnagel]

How about a saved pdf file? Then it wouldn't update in real time but we can always just repost

 

[Rick Hufnagel]

Nope... Just shows up as a file, no picture.

 

[Rick Hufnagel]

I guess a good old screen shot is the best way to display it

 

[Jim Haney]

The spreadsheet will send you a message for permission to type anything on it.

The PDF file has to be downloaded to anyones computer to open it.

 

[Rick Hufnagel]

How about this one

 

[Rick Hufnagel]

Thanks Jim!

This isn't working.

I think just adding the screen shots is the best way.

 

[Jim Haney]

Still have to download to open it

 

[Rick Hufnagel]

I think a large spreadsheet will be very difficult to read. I can't even get all of the fields into this one

 

[Rick Hufnagel]

That's not even legible

 

[Jim Haney]

Yes, It isn't readable and it won't enlarge

 

[Rick Hufnagel]

How about an excell file

 

[Rick Hufnagel]

Nope

 

[Rick Hufnagel]

I think the link in the original post is probably the best way.

What do you all think?
Thanks everyone for the help testing it out.

 

[John Matthews]

Let's see if it works

Rick - I just edited the original file via my google account.

I am not exactly certain what you are trying to achieve You can certainly share a simple spreadsheet, that other's can edit

John

 

[Rick Hufnagel]

John, thanks

I actually don't want others to be able to edit it. I just accidentally hit accept when your request came through. First time trying to do something like this. Kinda learning as I go. Haha

 

[Tom McIntyre]

I believe that browser extensions will allow the file to be opened without going through the download.

The previous version of the software made a jpeg image of pdf files (usually the first page) and then made that image a link to the file itself which opened in a new window like an attachment does. I liked that behavior, but the person who built it retired and no one else wanted to pick up the effort. One of the reasons is that the software that does the image generation has a know security vulnerability.

I did not think it was all that dangerous but most software folks equate security vulnerability with murder and mayhem.

 

[Rick Hufnagel]

Haha, I don't know what you posted, Tom, but it's definitely not a spreadsheet.

I figured out how to shut off requests to edit and just posted the link in the thread for standard American watch co. It's either working well, or no one looked at it yet, hahahaha. That way someone can look at with without having to download anything, and it will update in real time.

Thanks for taking the time to check in here.

 

[Tom McIntyre]

It is the address I found at your Google reference. Can you post a link to something in your Google docs that has view permissions set?

The code I used just shows whatever you address says is there. I have not used Google Docs much so am not really familiar with it.

 

[Rick Hufnagel]

Here is the sheet, is this what you wanted? If not let me know what you want to look at. Thanks

Standard American Watch Co, Pittsburgh

Sheet1 S/SA,Manuf,Serial,Grade,Adj?,Jewel,Finish,Dial,Style,Reg,Notes 273673 Acme,SA,Lancaster,35269,?,Y,15,Gilt,SS Roman,KW,Plain Acme,S,Hampden,81622,Lafayette?,N,15,Nickel,KW,Plain,H&A Book, strange grade Clipper,S,Hampden,278673,71,N,11,Gilt,KW,Plain,1980 price indicator Clipper,S,Illinoi...

docs.google.com

 

[Jim Haney]

Rick,

 

[Rick Hufnagel]

Thanks Jim.

 

[Tom McIntyre]

We have a markup code GVIEW that creates a window to display your Google Docs file. I have not used it, so I do not know why it is not working.

From what I have read so far, the feature requires a file type extension such as .xls. Your reference does not have a file type such as PDF, XLS, DOC...

 

[Jim Haney]

Tom,
It appears that you have 2 separate discussions going on in this thread?

 

[Rick Hufnagel]

Ok let's go for the gold here.
The goal is:
Standard american spread sheet, updated In real time and visible within the thread.

 

[Rick Hufnagel]

That's a win!

 

[Jim Haney]

Rick,
That should work. When I saw that you replied to this thread and clicked on the link in the email I got a message that I had to have Google Drive permission to view, so you may want to keep that in mind, I assume they contacted you for permission?

, I can see the spreadsheet fine when I open the email and view as i would on the MB.

Thanks

 

[Rick Hufnagel]

Awesome, thanks Jim

 

[Jane McIntyre]

Jane can read and modify with no Google account.

 

[Tom McIntyre]

I can see and use the spreadsheet, but that may be because I have been granted access in Google docs.

 

[Rick Hufnagel]

Wait, people can edit the sheet? I need to figure out how to axe that

 

[Tom McIntyre]

I think I was mistaken.They can select a single cell and they can zoom the image but they do not seem to have access to change. I was confused by the select action.

It is visible to guests but there may be associated permissions. I will check that. If there are usergroup permissions they will apply to the feature not individual insertions. More later...

 

[shutterbug]

That's what I get too. No ability to change it. Unless you meant that it updates as YOU change things.

 

[Rick Hufnagel]

Good, thank you. It does update as I change the original, and if you can't modify it, then we have achieved exactly what I was trying to do!

 

[Tom McIntyre]

You may highlight cells, rows and columns but that is the extent of it. That feature is probably useful for screenshots referencing the spreadsheet.

I wish it worked with uploaded attachments and I will probably continue to explore that.