Error
When users format functions into a table, the entries of the function builder are removed or converted to static text in ArcGIS for Excel.
| Número de ID del error | BUG-000154577 |
|---|---|
| Enviado | December 19, 2022 |
| Última modificación | June 5, 2024 |
| Relacionado con | ArcGIS for Excel |
| Versión encontrada | 2022.2 |
| Sistema operativo | Windows OS |
| Versión de sistema operativo | 11.0 64 bit |
| Estado | As Designed |
Información adicional
This is a limitation of Excel tables. Formulas are not supported in Excel table headers, and spilled array formulas are not supported in Excel table rows. See the Excel documentation for more information: https://support.microsoft.com/en-au/office/-spill-error-table-formula-8bfa1758-1be4-42f4-a974-c4d4bc513d4b.Solución alternativa
There are two workarounds:
- To keep the formulas and convert the table to a normal cell range: After formatting as a table, go to Table Design > Tools > Convert to range.
- To keep the table and convert the formulas to text or numbers: Right after adding the formulas, select the formulas, then go to Home and click the drop-down arrow next to the 'Paste' clipboard icon and select Paste as Values. After this, go to Home. In the Styles gtoup, select Format as Table.
Pasos para reproducir
ID del error: BUG-000154577
Software:
- ArcGIS for Excel
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri