Feedback by UserVoice

Manuel Rosendo Castro Iglesias

My feedback

  1. 260 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  2. 379 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

    Manuel Rosendo Castro Iglesias supported this idea  · 
  3. 1,275 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

    Some of the specific issues mentioned are addressed as follows:
    – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
    - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
    - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. …

    Manuel Rosendo Castro Iglesias supported this idea  · 
  4. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Manuel Rosendo Castro Iglesias commented  · 

    Good day.
    Dear aoki_taichi, we cannot blame any program for our own mistakes, nor pretend that they can correct them for us.
    If when we create a formula the result is incorrect, the first thing to consider is the possibility of having made a mistake.
    The purpose of the LET () function is precisely that, to be able to see in a transparent way what we write or say a formula, and detect these inconsistencies.
    So my suggestion would help, because declaring the "name" of the calculation gives us a much clearer view.
    Greetings.

  5. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Manuel Rosendo Castro Iglesias commented  · 

    To english by traslate.google.
    Thanks Roy, I partially agree with you.
    I explain:
    These are the variants to introduce formulas in an Excel Workbook.
    Excel native formula. Scope of application.
    Predefined.
    UDF VBA programmed formula. Scope Application with VBA.
    Scheduled is not always convenient for security reasons.
    Range with Name (formula), Scope Book / Sheet.
    Performance problems in iterative formulas.
    Name manager, unfiltered etc.
    LET cell scope.
    This new function allows us to solve the problems of the previous point, but it does not clarify what the formula refers to (it needs to name the name of the result variable, hence my suggestion).
    If this were combined with color highlighting (as has been proposed elsewhere, and as Excel does with ranges when editing the cell), it would allow the selection of that cell to understand not only its use, but also to what it refers.
    Allows you to assign, through Name Manager, a defined name to be used in scopes outside the cell.
    It would allow in the future, to be able to create a FORMT function (variable, format, xText / xValue) that similarly to Es.Error () wraps the formula and also shows the used format in the cell. This function I have not yet finished shaping it and therefore I have not proposed it. It will allow errors such as the “Mars Climate” in which the units were not detected to be avoided until it was late.
    By combining the last two systems (Name formula + Let) it is almost possible to replace any UDF in Excel.
    The best way to avoid silly mistakes is to be able to see in the formula bar what that cell does, and the best way is the LET function with my suggestion + Name defined.
    All this also makes it possible to create a sheet (handbook = Summary in which various things are annotated in order to keep them in mind when needed.) Which must be an essential sheet in any fairly complex book.
    Thank you.

    An error occurred while saving the comment
    Manuel Rosendo Castro Iglesias commented  · 

    Gracias Roy, estoy parcialmente de acuerdo con usted.
    Me explico:
    Estas son las variantes para introducir fórmulas en un Libro de Excel.
    Fórmula nativa Excel. Ámbito aplicación.
    Predefinida.
    UDF fórmula programada VBA. Ámbito Aplicación con VBA.
    Programada no siempre es conveniente por razones de seguridad.
    Rango con Nombre (fórmula), Ámbito Libro / Hoja.
    Problemas de rendimiento en formulas iterativas.
    Administrador de nombres, no filtrado, etc.
    LET ámbito de celda.
    Esta nueva función permite solventar los problemas del punto anterior, pero no clarifica a que se refiere la fórmula (le falta designar el nombre a la variable resultado, de ahí mi sugerencia).
    Si esto se combinase con el resaltado en colores (como ya se ha propuesto en otros lados, y tal como lo realiza Excel con los rangos al editar la celda), permitiría que al seleccionar dicha celda se pudiera comprender no solo su uso, sino que también a que cosa se refiere.
    Permite asignar mediante el Administrador de nombres, un nombre definido para usar en ámbitos fuera de la celda.
    Permitiría en un futuro, poder crear una función FORMT(variable, formato, xTexto / xValor) que de forma similar a Es.Error() envuelva la fórmula y muestre en la celda también el formato utilizado. Esta función aún no le he terminado de dar forma y por tanto no la he propuesto. Permitirá que se eviten errores como el la “Mars Climate” en la cual no detectaron la incompatibilidad de las unidades hasta que fue tarde.
    Mediante la combinación de los dos últimos sistemas (Nombre formula + Let) casi es posible sustituir cualquier UDF en Excel.
    La mejor forma de evitar errores tontos es poder ver en la barra de fórmulas que es lo que esa celda hace, y la mejor manera es la función LET con mi sugerencia + Nombre definido.
    También todo ello permite crear una hoja (prontuario = Resumen en que están anotadas varias cosas a fin de tenerlas presentes cuando se necesiten.) que debe ser una hoja imprescindible en cualquier libro medianamente complejo.
    Gracias.

    Manuel Rosendo Castro Iglesias shared this idea  · 
  6. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
  7. 221 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  8. 808 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    Manuel Rosendo Castro Iglesias supported this idea  · 
  9. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  10. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  11. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  12. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  13. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  14. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  15. 23 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  16. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  17. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  18. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  19. 27 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
  20. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Manuel Rosendo Castro Iglesias supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base