Results 1 to 2 of 2

Thread: Automate Math worksheet in LibreOffice Calc

  1. #1
    Join Date
    Sep 2005
    Xubuntu 14.04 Trusty Tahr

    Automate Math worksheet in LibreOffice Calc

    Does anyone know how I could do the following in LibreOffice Calc:

    Cell A2 contains the value: 2+3
    Cell A3 should contain the student/users answer, in this case: 5
    Cell A4 gives a red X for wrong or a green check for correct

    Without having it process =2+3 how can I have LibreOffice Calc convert a string 2+3 to process it like =2+3 ?

    If I have to do it manually that's ok, I thought I could automate it.
    Dell XP 8700 - Windows 10 64-bit Fast Ring - i7 4790 8GB 1GB 250GB SSD 1TB HDD
    HP Stream 13 - elementary Loki 64-bit
    HP Envy M6 - Windows 10 64-bit

  2. #2
    Join Date
    Apr 2012

    Re: Automate Math worksheet in LibreOffice Calc

    You could do it the other way around, I think i.e.

    - create a cell to evaluate the answer =2+3

    - use the FORMULA() function to return the text formula (literally =2+3) into A2

    You can trim the = off the front e.g. with the MID string function i.e. if A1 contains your actual =2+3 formula, then


    inserts literal string 2+3


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts