1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Introducing WizoGrid - Integrated Spreadsheets

Discussion in 'General Discussion' started by ajayre, Sep 20, 2019.

  1. ajayre

    ajayre Alibre Super User

    Read and write parameters using functions. Import and export to Excel. Multiple worksheets. Save spreadsheets into part and assembly files. PDF manual with step-by-step instructions.

    WizoGrid-Demo.gif

    Download from here: http://www.wizotools.com

    Andy
     
    PPi, Jonathan, TimoCAD and 7 others like this.
  2. Ralf

    Ralf Alibre Super User

    Thank you very much!
     
  3. oldfox

    oldfox Alibre Super User

    Andy, will this work with LibreCalc?
     
  4. DavidJ

    DavidJ Alibre Super User Staff Member

    You don't need any installed spreadsheet software for Wizogrid to function. Import & export is via xlsx file, which I believe Libre Calc supports.
     
  5. oldfox

    oldfox Alibre Super User

    Thanks David. I'll check it out.
     
  6. Lew_Merrick

    Lew_Merrick Alibre Super User

    David -- Actually there are (about a dozen) things in Libre Calc that do not "translate" well into XLSX format! Whereas an ods (Libre Calc native format) is larger than an xlsx format spreadsheet, there are many fewer "engineering functions" in the xslx format than the ods format. -- Lew
     
  7. GIOV

    GIOV Senior Member

    Hi Ayaire:
    I do like the same concept. I have excel 2007.
     
  8. Lew_Merrick

    Lew_Merrick Alibre Super User

    Hi Andy -- I downloaded it yesterday (afternoon) and ma still "playing with it" to figure out the "details" as I hope to use it. My initial thought is that being able to "export" the dataset and edit it "externally" would fall into the "good things" category (says the guy who would not have to code it). -- Lew
     
  9. ajayre

    ajayre Alibre Super User

    You can't export "datasets" only spreadsheets. This is a spreadsheet based approach so it won't be possible to export "datasets".

    Andy
     
  10. Lew_Merrick

    Lew_Merrick Alibre Super User

    Hi Andy -- Ah, but moving "about" the "Sub-Window" can be painful in the spreadsheet as opposed to being able to do so in a "full screen" spreadsheet. I can hope can I not? -- Lew
     
  11. Ralf

    Ralf Alibre Super User

    Hi Andy,

    Thank you for these 3 options to arrange the interface location:

    Interface-Locations.png

    It's good to work with!

    Right.png
     
    Jonathan and ajayre like this.
  12. MKR

    MKR Member

    @ajayre

    =SET is not working for me, could the problem be danish characterset and comma separation?

    /Michael
     

    Attached Files:

  13. ajayre

    ajayre Alibre Super User

    Yes, it's related to the language. I want the behavior to match Alibre Design. How does that represent values with commas and decimal points on your PC? Decimal point for thousands and comma for fractions?

    Andy
     
  14. MKR

    MKR Member

    In the WizoGrid the vallue is displayed like this "64,0312423743285" not "64.0312423743285".
    Alibre is using "," for decimals not "."
    Hope that answer your question?

    /Michael
     
  15. simonb65

    simonb65 Alibre Super User

    @ajayre , You just need to set the locale (use CultureInfo if your using C#, setlocale if your using C++) to the same as the parent system and your string parse (from text box to float/double) will just do the right thing. Localization is always the last thing people consider, but it should be the first.
     
    Last edited: Sep 25, 2019
  16. idslk

    idslk Alibre Super User

    Hello Andy,

    SET does not work here, too. (also with a non fraction value)
    GET works with the system values for seperators. DESIGNPATH and DESIGNNAME works also.
    upload_2019-9-24_11-4-22.png
    upload_2019-9-24_11-1-4.png
    Regards
    Stefan
     
  17. NateLiqGrav

    NateLiqGrav Alibre Super User

    @idslk
    The functions are
    =GETPARAMETER("Name")
    =SETPARAMETER("Name", Cell)

    EDIT: Ignore that - The function names were changed to
    =GET("Name")
    =SET("Name", Cell)
     
    Last edited: Sep 25, 2019
  18. idslk

    idslk Alibre Super User

    Hello Nate,
    thanks for your Info.
    here's a snapshot from the manual:
    upload_2019-9-24_21-13-41.png

    no matter, i've tried your functions:
    I get 0 if i use GETPARAMETER:
    upload_2019-9-24_21-15-52.png

    If i use only GET, i get the right value of 30.

    If i use SETPARAMETER, it results in the same as SET:
    upload_2019-9-24_21-17-54.png

    Might be another thing?

    Regards
    Stefan
     
  19. ajayre

    ajayre Alibre Super User

    That was true for the beta you had, but I shortened them per DavidJ's suggestion - the change is in the release notes.

    Andy
     
  20. MKR

    MKR Member

    In Germany you use comma as a decimal separator like in Denmark, not period like in USA and other countries.
    I think that is the problem?

    https://en.wikipedia.org/wiki/Decimal_separator

    /Michael
     
    Last edited: Sep 25, 2019

Share This Page