Does Document support Date format with locale code

[Serhii]

Hi there,

I've got next issue. I opened existing xlsx file using XlsIo lib and just save it without any mods.

After I open this newly created xlsx file using ej2-react-documenteditor I figured out that date cells showed like a numbers. After some debugging I figured out that date format in my xlsx file looked like 

[$-409]ddd, mmmm d, yyyy

So, why ej2-react-documenteditor doesn't treat such format well and how can I fix it? 

[Balamurugan Shanmugam]

Hi,

The DocumentEditor component supports Word files, but it doesn't support XSLX files. So, could you please confirm if you are referring to the spreadsheet component?

Regards,

Balamurugan S

[Serhii]

Hi  Balamurugan Shanmugam,

I use next configuration

import {

DocumentEditorContainerComponent,

Toolbar,

WordExport

} from "@syncfusion/ej2-react-documenteditor";

DocumentEditorContainerComponent.Inject(Toolbar, WordExport);

DocumentEditorContainerComponent {...props}/>

[Balamurugan Shanmugam]

Hi,

DocumentEditor doesn't support opening xlsx files. We are not sure about how to use this in your application. So, could you please share the runnable sample that was used on your end? Thereby, we will analyze further and provide you with the appropriate solution at the earliest.

Regards,

Balamurugan S

[Serhii]

Hi Balamurugan Shanmugam,

I'm sorry for confusion, You are right I use  spreadsheet component

import { SpreadsheetComponent } from "@syncfusion/ej2-react-spreadsheet";

[Janakiraman Sakthivel]

Hi Serhii,

We have validated your reported query, and we were able to replicate that. And we would like to let you know that currently, we don’t have support for the mentioned custom date format in spreadsheet. However, we have confirmed this as an improvement and logged it as a feature. It will be available in any of our upcoming releases. You can communicate and track the status of the feature using the below link from our feedback portal.

Feedback link for tracking purposes: https://www.syncfusion.com/feedback/33274/provide-support-to-use-custom-date-time-formats-with-semicolon-followed-by-at-the

Unfortunately, we are unable to implement this feature immediately. Since we have some more bug fixes and features that are prior than this feature is in queue scheduled for upcoming releases, we can’t commit this feature at present. We usually have an interval of at least three months between the releases.

At the planning stage for every release cycle, we review all the open features once again and finalize features for implementation based on specific parameters including product vision, technological feasibility, and customer interest. Once we have anything definite to share about these features implementation, we will move the feedback to scheduled status with the tentative release timeline. We appreciate your patience until then.