Skip to main content
shark
Associate III
April 6, 2020
Solved

modify texts.xlsx

  • April 6, 2020
  • 12 replies
  • 2814 views

When Microsoft excel 2016 opens texts.xlsx, it will report some error. If I accept corrections and save the file, the designer can not recognize the file.

the text resource accumulates more and more, I must re-order the content. Which version or what other software should I use to modify the texts.xlsx.

This topic has been closed for replies.
Best answer by shark

Based on previous check result, I solved it this way.

Copy an old texts.xlsx file from older 4.12 version, delete content in sheets, paste new content from current xlsx file, Save it. OK.

NOTE, table column order is different between version 4.12 and 4.13. so copy colums one by one.

hahaha

thank you, Martin.

12 replies

Martin KJELDSEN
Principal III
April 6, 2020

Please show me a screenshot of the error. You can use any Excel version that knows the xlsx format. The hint may be in the error you're getting when opening (corrupt file, etc.)

/Martin

shark
sharkAuthor
Associate III
April 6, 2020

0693W000000VMaNQAW.png

the chinese message is: some content has problem, shall I recover it?

If I select yes, designer will failed to load it.

if I select no, ms excel will failed to open the file.

even if I open the original file from your demo example, same error message is shown.

Martin KJELDSEN
Principal III
April 6, 2020

Maybe this is some sort of language/locale issue. Which demo is it? I'll try here.

/Martin

shark
sharkAuthor
Associate III
April 6, 2020

0693W000000VN8yQAG.pngevery demo are failed, this is screen shot of analog clock.

there are 3 sheets in file? I see only 2, the error message looks like "xl/tables/table3" has error and is removed

Martin KJELDSEN
Principal III
April 6, 2020

I'm not seeing any errors in any of the demos i've tried. Let me try to attach a file here and you can check that. If it works, maybe it's a download issue.

shark
sharkAuthor
Associate III
April 6, 2020

This file opened successfully. Let me create a new project and check again.

shark
sharkAuthor
Associate III
April 6, 2020

At sametime, please check the file for me .

Martin KJELDSEN
Principal III
April 6, 2020

Yours has errors and needs to be recovered, excel tells me.

Martin KJELDSEN
Principal III
April 6, 2020

I could give you some md5 hashes of different files if you want to check if something has happened to your files

shark
sharkAuthor
Associate III
April 6, 2020

however, this xlsx file is generated and updated by designer version 4.13. I have using it for several month.

After I checked some old demo projects, maybe:

if the project is created by older 4.12, even if updated by 4.13, it is ok

if the project is created by current 4.13, the problem occurs.

I have created a simplest new demo just now, the same problem occurs.