Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: parser for the formulas style of excel

  1. #11
    Quote Originally Posted by Edcronos View Post
    Of course it is far from something that can be taken seriously and has to have a series of support and pre-verification functions of data and structure
    But I do not think it's impossible for an experienced programmer
    There is no question that it is possible. The question is whether you must reinvent the wheel.

    Rather than pasting code block after code block, perhaps you can explain in human terms what it is you're trying to accomplish.

  2. #12
    Em vez de colar bloco de código após o bloco de código, talvez você possa explicar, em termos humanos o que é que você está tentando realizar.
    really,
    Sorry
    Even because it's not something that's working


    Não há dúvida de que é possível. A questão é se você deve reinventar a roda.
    I believe that the wheel is always being reinvented,
    I think you can and you should

    Then, what would be the purpose of thinbasic, freebasic, java, c ++ ...
    They all do the same thing differently,


    But what I intend to do is not even close to the proposal of these ideas

    It would be just to have an option to write
    And (test1,Or(testB , test2), test3)
    instead of
    test1 And (testB Or test2) And test3
    Some even accept the "()" to separate tests, but others like the vba have to structure in a very complex way to put everything together
    I put a cascade structure
    if Test1 then
        if testB Or test2 then
            if Test3 then
    code
            end if
       end if
    end if
    
    As I said "look like the excel style"
    My use is for arrays,
    So you do not have to keep typing a bunch of lines with "for and if" with each new filter idea, and check
    What I had set up despite something rude, and rather limited, worked for simple things

    Well, I do not know if you can understand my explanation.
    Last edited by Edcronos; 29-01-2017 at 10:37.

  3. #13
    Super Moderator Petr Schreiber's Avatar
    Join Date
    Aug 2005
    Location
    Brno - Czech Republic
    Posts
    7,128
    Rep Power
    732
    Hi Edcronos,

    then what about this, which works already:
    All(test1, Some(testB , test2), test3)
    @Harsh: +1


    Petr
    Last edited by Petr Schreiber; 30-01-2017 at 11:35.
    Learn 3D graphics with ThinBASIC, learn TBGL!
    Windows 10 64bit - Intel Core i5-3350P @ 3.1GHz - 16 GB RAM - NVIDIA GeForce GTX 1050 Ti 4GB

  4. #14
    Hi
    Can be a solution for simpler cases
    Do these functions solve all the questions, then show the result,

    or leave the tests when it is no longer possible a false or true?
    All(
    Test1 = true
    Test2 = false "exits function with value = false"
    Test3 = true "is not tested because it has already had a previous false"
    Test4 = true
    ...)
    SOME(
    Test1 = true "exits function with value = true"
    Test2 = false "is not tested because it has already had a previous true"
    Test3 = true
    Test4 = true
    ...)

    Is there any counting function for true or false tests?
    countTrue(
    Test1 = true
    Test2 = false
    Test3 = true
    Test4 = true
    )
    =3 questions true
    Last edited by Edcronos; 30-01-2017 at 16:08.

Page 2 of 2 FirstFirst 12

Similar Threads

  1. Excel COM question...
    By Gerald Sutherland in forum COM
    Replies: 77
    Last Post: 20-08-2014, 01:41
  2. MLGrid for evaluating formulas
    By Petr Schreiber in forum Sources, Templates, Code Snippets, Tips and Tricks, Do you know ...
    Replies: 0
    Last Post: 27-01-2009, 14:04
  3. MS Excel as 3D engine :D
    By ErosOlmi in forum Development
    Replies: 3
    Last Post: 13-03-2008, 01:09
  4. Equivalent VBA Excel code
    By marcel in forum COM
    Replies: 12
    Last Post: 08-11-2007, 16:18

Members who have read this thread: 0

There are no members to list at the moment.

Tags for this Thread

Posting Permissions

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