Editar formulas de excel en Notepad
-
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.
-
@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
-
@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.
-
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
-
@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. -
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
TerryPS I still think it’s a lot of work for little gain.
-
@Terry-R Thank You!