Community
    • Login

    Editar formulas de excel en Notepad

    Scheduled Pinned Locked Moved General Discussion
    7 Posts 2 Posters 36 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Jhorbam Baena OrozcoJ
      Jhorbam Baena Orozco
      last edited by

      Cordial saludo a todos.

      Consulta si pego una formula de celda de excel como esta:

      =SUMAPRODUCTO(($E$5:$E$67=$D$70)($F$5:$F$67=$A$74)($I$5:$I$67))

      Notepad++ resaltara las palabras clave y símbolos como lo haría el editor de formulas de excel, usando colores?

      No hablo de código VBA, solo formulas de celda. Dado que el editor de excel en ocasiones no alcanza o no permite si se desea copiar una formula 2 veces y editar la segunda guiandose por la primera, y el block de notas no resalta en colores las palabras clave y símbolos.

      Gracias por su respuestas.

      Terry RT 1 Reply Last reply Reply Quote 0
      • Terry RT
        Terry R @Jhorbam Baena Orozco
        last edited by Terry R

        @Jhorbam-Baena-Orozco said in Editar formulas de excel en Notepad:

        Cordial saludo a todos.

        Consulta si pego una formula de celda de excel como esta:

        Most posters will attempt to ask a question in English. However in your case I decided to translate it and post here:


        Greetings to all.

        I wonder if I can paste an Excel cell formula like this:

        =SUMAPRODUCTO(($E$5:$E$67=$D$70)($F$5:$F$67=$A$74)($I$5:$I$67))

        I’m not talking about VBA code, just cell formulas. The Excel editor sometimes isn’t enough or doesn’t allow you to copy a formula twice and edit the second time based on the first, and Notepad doesn’t highlight keywords and symbols in color.

        Thank you for your responses.


        However even reading it in English I’ve still no idea on what you are attempting to do. Bear in mind that an Excel formula will reside in Excel, not in Notepad++. Notepad++ does not work with Excel .XLSX files as they are binary files, not text files.

        You will need to supply more information and this time, please use a translate service to post in English. You will have many more responses posting in English.

        Terry

        Jhorbam Baena OrozcoJ 1 Reply Last reply Reply Quote 1
        • Jhorbam Baena OrozcoJ
          Jhorbam Baena Orozco @Terry R
          last edited by

          @Terry-R
          Ok, I’m not trying to open an Excel file directly with Notepad++. I want to be able to use Notepad++ to edit Excel formulas in it. As I mentioned, you often want, like in my case, to copy the formula twice into Notepad and be able to adjust the second time using the first one as a guide. Then, copy and paste it into the Excel cell to verify that it works. This applies to large formulas. However, Windows Notepad doesn’t colorize formula syntax, so I’m curious to know if Notepad++ colors formulas in cells like =SUM(A1:A150).

          And sorry for having put the initial post in Spanish.

          Terry RT 1 Reply Last reply Reply Quote 0
          • Terry RT
            Terry R @Jhorbam Baena Orozco
            last edited by Terry R

            @Jhorbam-Baena-Orozco

            A quick Google search turned up this Notepad++ posting, I was actually one of the repliers in that, it was a long time ago, but I’m doubtful there has been any work done on it since.
            Heave a read of this post.

            The real issue here is that as you would normally have the formulae inside of an Excel “binary” file, Notepad++ is the wrong application to attempt to edit it.

            Hence you would have to copy the formulae into Notepad++, then apply the “language” as stated in that post. It’s by applying a language that you get the colourisation of keywords etc.

            It all seems a lot of work for little gain.

            Maybe someone else has a better idea?

            Terry

            Jhorbam Baena OrozcoJ 1 Reply Last reply Reply Quote 0
            • Jhorbam Baena OrozcoJ
              Jhorbam Baena Orozco @Terry R
              last edited by

              @Terry-R
              Again, I don’t want to open an Binary Excel file directly in Notepad++.
              Currently, I work on some formulas in my Excel workbooks directly in the Excel formula editor if they’re not too complex or large. When this happens, I copy the formula to Windows Notepad and make the changes there, but Windows Notepad doesn’t highlight the syntax, and editing a complex formula becomes tedious. That’s why I’m looking for an alternative to the Excel formula editor and Windows Notepad for tasks like the one described above.

              Terry RT 1 Reply Last reply Reply Quote 0
              • Terry RT
                Terry R @Jhorbam Baena Orozco
                last edited by Terry R

                @Jhorbam-Baena-Orozco

                So we at least agree opening the binary file isn’t the right method and also agree that copying it to another “editor” to make the changes is possibly achievable.

                However as I said when referring to that old post, the UDL supplied there may not have been updated to include any recent keywords added to Excel.

                You would need to do your research. If a file is easily described as being of a particular language then Notepad++ will apply that language description and then colourise the keywords etc. Generally this means the first line or the file extension is known to be of that language.

                As Excel isn’t in the default list of languages you would need to add that (as per the old post). Then once you copied the formula into Notepad++ you would select that language from the menu to start the colourisation of keywords etc.

                Good luck
                Terry

                PS I still think it’s a lot of work for little gain.

                Jhorbam Baena OrozcoJ 1 Reply Last reply Reply Quote 1
                • Jhorbam Baena OrozcoJ
                  Jhorbam Baena Orozco @Terry R
                  last edited by

                  @Terry-R Thank You!

                  1 Reply Last reply Reply Quote 1
                  • First post
                    Last post
                  The Community of users of the Notepad++ text editor.
                  Powered by NodeBB | Contributors