WordPress.org

Ready to get started?Download WordPress

Forums

Excel in my posts... (14 posts)

  1. Jakeeck
    Member
    Posted 12 months ago #

    I put an excel spreadsheet into my post, but I'm having trouble with a few things:
    (Here's a link to post: http://caffeinecamel.com/sample )

    1. I set it so users can input data, but I only want them to be able to input the "quantity" field, right now they can edit any cell. Locking cells doesn't work because then skydrive won't open the file, which is where I get the embed code from.

    2. When they sort a column, the alternating row colors gets messed up, is this even possible to fix?

    --Is there a plug-in or anything I can do that will let me upload my spreadsheet with the options I specified?

  2. This would be a great question to ask the WebApp team at Microsoft. Unfortunately this has nothing to do with WordPress so we can't really help out much.

  3. Jakeeck
    Member
    Posted 12 months ago #

    Well I did ask if anyone knew of a plug-in that would allow me to do this. Doesn't have to be excel, maybe a table plug-in that lets me import excel data and lets me customize things like I want. That's WordPress related I would say.

  4. Sure, I answered the question related to #2. Perhaps someone else with spreadsheet/WordPress experience could suggest a plugin.

  5. WPyogi
    Volunteer Moderator
    Posted 12 months ago #

    Haven't used them and don't know if they'll do what you want, but there are several related to Excel:

    http://wordpress.org/plugins/search.php?q=excel

    Also look at TablePress - tons of functionality and amazing support from the developer:

    http://wordpress.org/plugins/tablepress/

  6. Jakeeck
    Member
    Posted 12 months ago #

    Thank you,

    I looked at a lot of the excel plug-ins and I have TablePress. However, none of them allow for a user to enter data, at least I'm pretty sure. The user entering data to get a final calculation is what I really need.

  7. Pioneer Valley Web Design
    Member
    Posted 12 months ago #

    A Mod who is anti--- is not helpful = review how to use MS docs in the cloud at:

    http://office.microsoft.com/en-us/web-apps-help/introduction-to-excel-web-app-HA010378338.aspx

    Please read it...

  8. Huh? Patrick chimed in about the Excel question.

    I mean, thanks for providing Jakeeck that link but most of us including moderators don't know much about MS Excel.

  9. Andrew
    Forum Moderator
    Posted 12 months ago #

    @Jan, a mod who is 'anti-is not helpful' is a mod who is helpful :)

  10. I am 'anti-is' this whole chain of thought! ;)

    *Has more coffee and goes to look in No Replies*

  11. @Seacost Web Design: Thanks for providing the link but it doesn't support what the OP asked regarding points one and two.

    Locking cells doesn't work because then skydrive won't open the file, which is where I get the embed code from.

    That's something that MS could look into, perhaps suggest it as an improvement?

    If your intended functionality of the sheet is to serve as a total cost calculator (# of unites x price = total cost) then you don't need to use a spreadsheet. You can build a calculator using some basic coding. The links and resources below may be helpful.

    http://wordpress.org/plugins/calculated-fields-form/
    http://wordpress.org/plugins/wp-creator-calculator/
    http://www.codecademy.com/courses/web-intermediate-en-jfhjJ
    http://www.ultimatecalculators.com/economic_order_quantity_calculator.html

  12. Jakeeck
    Member
    Posted 12 months ago #

    Appreciate it, but I have an excel speadsheet of about 500 items that I want to display on the page and have people enter an amount, and it'll calculate it.

    I don't need the cells to lock anymore, i just need something that will allow me to create a table or spreadsheet where people can enter something and it will calculate

  13. Jakeeck
    Member
    Posted 12 months ago #

    embedding the webapp into my page works for me, but in talking to other people, they can't see it. Not sure if its because they don't have excel or something?

  14. If they can't see it then their browser doesn't have the appropriate settings or extensions required by Microsoft Web Apps.

Reply

You must log in to post.

About this Topic

Tags

No tags yet.