Thousand Separator support for different region in Excel addin

office 365 1 Reputation point
2023-01-31T06:50:01.47+00:00 
Hi Team,
 
  - We are offering a Excel addin where user can upload local excel and save it to onedrive, The addin is available on office store. 
  - In this Addin we are providing one feature where user can upload numbers in any region format(thousand separator).
    For ex: United States         - Thousand separator is ,
            Some European country - Thousand separator is  . or space
  - This separators are behave normally on local copy of excel but when we upload it to onedrive account and tried to retrieve it back then the formatting is not retained.
  - Is that any way to retained the same format?
  
   Note : We are using Graph Api to get the excel data from OneDrive account.
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,592 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,464 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
810 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,489 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shivam Dhiman 5,946 Reputation points
    2023-02-02T13:18:21.2533333+00:00

    Hi @office 365

    As per my knowledge, it's not possible to get data in a local regional format for excel using Graph API. Since this feature/functionality is presently not available, you can submit a feature request idea using this support link, which will be monitored by Microsoft team and make the enhancements to Microsoft Graph APIs. I will also upvote for you.

    Hope this helps.

    If the answer is helpful, please click Accept Answer and kindly upvote. If you have any further questions about this answer, please click Comment.

    0 comments