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.
12,225 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,950 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,136 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,966 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Shivam Dhiman 6,056 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 No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.