Home › Member Posts › NP3U spreadsheet test

29 comments on “NP3U spreadsheet test”

  1. Hmmm… veddy interesting.

    I was able to add/edit cells in the browser and then I could download it to my computer as an Excel file (only as a “read only” file, but it can be “saved as” a file with another name). I don’t see yet how to save it back to the server/website. I will leave it as I edited it within the browser, exit the web site, then log on again and take a look at it.
    Ken

  2. Me again…

    Looks like the changes I made to the spreadsheet are sticky, ‘cuz they are still there. However, now I am unable to directly enter data into a cell. I must click on the “Edit” button and then add/change the data for each cell.

    I’ll keep playing during the morning.

    Good find, Ed… I think 🙂

    Ken

  3. OK… I figured it out. One must “double” click a cell to add/edit. I CAN directly enter data into a field without resorting to using the “Edit” button on the menu bar.

    Nice…

    Ken

  4. By golly that does work! Cool!

    Is there a way for us to see multiple tabbed sheets, like in my NP3U spreadsheet? I know, I know, I’m never satisfied.

    If we can’t see tabbed sheets the spreadsheet might become really large. Or, I could just post the first sheet and then post two replies that include the other two sheets, so we have three separate spreadsheets.

    73,
    Pat, NG1G

  5. I was easily able to cut and paste some data from one of my spreadsheet’s tabs. All you have to do is highlight a cell and press CTRL-V. Done!

    I like this very much! Thanks, Ed!

    Pat

  6. You’re welcome. I wish I could get it to work. On my computer the toolbar contains only the PDF and Excel buttons (leading me to believe that the spreadsheet is in read-only mode).

  8. By clicking on the “Settings” (menu bar, right side) you can set the number of rows and columns. To reduce the size of the spreadsheet, I arbitrarily changed it to 30 rows and 15 columns. Of course, you can easily change it to your preference. The default was 100 rows and 26 columns.

    I tried unsuccessfully to select the first 3 rows that I put my initial entry in for test, with the idea of deleting the rows like one can do in Excel. Didn’t work. I’ll later just delete what is in the cells.
    Ken

  11. I changed the columns to 7. This is very easy to edit so far. Is there a way to re-size the window so that the entire sheet appears without the need to scroll?

    Pat

  13. Ken,

    If you can give me a link to where you got this I’ll take a look at the documentation and see what its features are. It may have more capabilities than we are using right now.

    Pat

  14. Hmmmm the link didn’t show. I’ll try again. Delete leading and trailing asterics(*)

    *****http://wordpress.org/extend/plugins/dhtmlxspreadsheet/*****

  15. See comment above. BTW… this is all Ed’s findings. The only thing I did was be the first to try it out 🙂
    73, Ken

  16. Here’s another web site with info… again, remove asterics(*)

    *****http://dhtmlx.com/docs/products/dhtmlxSpreadsheet/index.shtml?mn*****

  17. And here is yet another link…

    *****http://docs.dhtmlx.com/doku.php?id=dhtmlxspreadsheet:pluginguide_wordpress*****

  19. Thanks, Ken.

    They also have an app called tabbar, which appears to do exactly what I was asking about.

    There’s also one called scheduler, which looks like it would allow for better visual representation of contests. The calendar in WordPress is not easy to use for events that occur over more than one day. This one looks like it would be.

    So in the spreadsheet, autowidth=7 will allow us to view all 7 columns without scrolling.

    I’ll keep reading

    Pat

  22. OK… autowidth is true, and math is true. However, I still have to use scroll bar to see right hand side of the spreadsheet.

  23. OK… I adjusted the column widths and slightly changed the column titles and now everything appears on my screen with no horizontal scrolling necessary.
    Ken

  26. OK… I have looked at this on my laptop screen (1280 x 800) and my 21″ (4:3) monitor (1152 x 864)and it looks good on both.

    I believe that the width limitation that I’m seeing is a posting limitation and NOT something that we can set/adjust with the spreadsheet. If you notice, the box width of the spreadsheet is just about the same width horizontal bar just above the page title (NP3U Spreadsheet test). Actually, the horizontal bar width is 920 pixels and the division width of the spreadsheet box width is 909. Found this in the HTML source code.

    All that being said, we probably don’t need to worry about that. The current width should suffice for our purposes.

  27. I agree on the width. Two of the sheets I created go to column “G” and one only goes to “C”, so visibility shouldn’t be an issue unless someone gets verbose in a cell.

  28. One thing that I just noticed in the “Using the plugin” for Spreadsheet. I assume this is a default condition.

    It says, “Please note, the following users groups can edit Spreadsheet:
    Administrator;
    Editor.”

    I don’t know if that means “edit the program” or edit the spreadsheet, but I’ll log on with my “Member” category log in (K4JHG) and see what happens.

  29. Somehow, a comment that I thought I was sending from K3IU user name, got sent from user name K4JHG and apparently is in the process of being moderated. There… I just approved it.

    Anyway, K4JHG is in the member category and I was not able to make any changes to the spreadsheet while logged in with that user name.

    So, unless the permissions for this plug-in can be changed, its usefulness is limited to admins and Editors.

    Ken

Comments are closed.