Bug
When users format functions into a table, the entries of the function builder are removed or converted to static text in ArcGIS for Excel.
| Bug-ID-Nummer | BUG-000154577 |
|---|---|
| Eingereicht | December 19, 2022 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | ArcGIS for Excel |
| Gefunden in Version | 2022.2 |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 11.0 64 bit |
| Status | As Designed |
Zusätzliche Informationen
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.Workaround
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.
Schritte zur Reproduzierung
Bug-ID: BUG-000154577
Software:
- ArcGIS for Excel
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen