Skip to content

Custom function ID naming requirements are unclear #4039

Closed
@parched

Description

@parched

This page says

use characters A through Z, numbers zero through nine, underscores, and periods.

On https://learn.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-json it says

contains only alphanumeric characters and periods
... unique within the scope of the file. That is, no two function objects in the metadata file should have the same id value

  • Are lowercase letters allowed?
  • If so, are these distinct? "MYFUNC" vs "myfunc"
  • I noticed in the sheetx.xml the periods are converted to underscores. Does that mean "MY.FUNC" is not distinct from "MY_FUNC"?

Document Details

Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions