1. Home
  2. Forum
  3. React - EJ 2
  4. Cut off data after open excel file by spreadsheet component

Cut off data after open excel file by spreadsheet component

Hello

I'm using component : https://ej2.syncfusion.com/react/documentation/spreadsheet/open-save/ in my application. I realized that after opening the file, data is cutoff. It's like I have very long text in B2 cell, in C2 cell I have nothing however the cell A2 is hiding the text. Below screen show versions:

  1. before loading to the component (when I open the file using Excel on my computer)
  2. after loading to the spreadsheet component


Screens show as well more issues:

  1. cut off data
  2. gridlines shown even though in source excel they are not shown
  3. lost formatting - row 1 has a dotted fill pattern style, this is not visible after loading in spreadsheet component.

Could you advise what maybe the solution (or workaround) for there problems?
I would really appreciate any help.


4 Replies
SP Sangeetha Priya Murugan Syncfusion Team May 20, 2022 08:57 AM UTC

Hi Elzbieta,


Before, we proceed further please share the below details.


1. Please share the issue replicable excel file.

2.If possible, please share the issue replicable sample or spreadsheet rendering codes.

3. Video demonstration of this issue.

4.Essential studio product version

5. Please share the saved JSON data of spreadsheet by using saveAsJson method in the text file format (which contains applied formula details).


Could you please check the above details and get back to us with the above requested information, based on that we will check and provide you a better solution quickly.


Regards,

Sangeetha M


EL Elzbieta May 20, 2022 11:07 AM UTC

Hi 


I added all this information to the ticket #379981. I thought that maybe two different channels could speed up a little bit.

Excel file & video attached.

I'm using version 20.1.56.

Steps to reproduce:

  1. starting a new react project with typescript: npx create-react-app my-app --template typescript
  2. ​cd my-app  & npm start --> it seems it works :)
  3. installing syncfusion : 
    4. npm install @syncfusion/ej2-react-spreadsheet --save

    and adding .css references

  4. adding code snippet from https://ej2.syncfusion.com/react/documentation/spreadsheet/open-save/#open 
    1. used app.tsx 
    2. removed args from list of beforeOpen parameter becuase VS code threated this as error
  5. Saving or running npm install to see in the browse and openning like in the video.


If you have any more questions feel free to reach out.

Kind regards

Ela

 ReactProblems.zip


Attachment: ReactProblems_4efc97e1.zip

GK Gayathri KarunaiAnandam Syncfusion Team May 26, 2022 02:04 AM UTC

Hi Elzbieta,


We are able to replicate the issue and we suspect that the issue is due to our sub components. We are working on this with high priority so we I'll update you with further details on May 26th, 2022 and we appreciate your patience until then.


Regards,

Gayathri K


GK Gayathri KarunaiAnandam Syncfusion Team May 27, 2022 03:56 PM UTC

Hi Elzbieta,


Query 1: A1 in excel contains a very long string


We have checked your requirement. Currently text overflow support is not available in the Spreadsheet control, we have logged this as improvement which will be available in any of our upcoming release and appreciate your patience until then. You can track status by using the below feedback link,


https://www.syncfusion.com/feedback/12592/text-overflow-support 


Query 2: gridlines are shown even if in the source are not shown (I know there is a button to change that, but I need no gridlines programmatically as a source excel file


In your excel file, you have used background color for the cells in which you doesn’t have grid line which is its own architecture. But in our Spreadsheet component, if you apply background color the gridlines doesn’t disappear. Please find the attachment to see the video demonstration of the spreadsheet and excel behavior.


Query 3: fill of cells (pattern style like dotted) seems to be unsupported 


Currently text pattern support is not available in the Spreadsheet control, we have logged this as an improvement which will be available in any of our upcoming release and appreciate your patience until then. You can track status by using the below feedback link,


 https://www.syncfusion.com/feedback/35243/need-to-provide-support-for-fill-pattern-in-spreadsheet


Regards,

Gayathri K


Attachment: background_color_fe9433c2.zip

Loader.
Up arrow icon