Skip to main content
shark
Associate III
Apr 6, 2020 8:39 AM UTC
Solved

modify texts.xlsx

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.
shark
sharkBest answer
Associate III
Apr 6, 2020 12:50 PM UTC

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
Apr 6, 2020 9:27 AM UTC

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
Apr 6, 2020 9:33 AM UTC

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
Apr 6, 2020 10:53 AM UTC

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

/Martin

shark
sharkAuthor
Associate III
Apr 6, 2020 11:04 AM UTC

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
Apr 6, 2020 11:09 AM UTC

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
Apr 6, 2020 11:12 AM UTC

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

shark
sharkAuthor
Associate III
Apr 6, 2020 11:17 AM UTC

At sametime, please check the file for me .

Martin KJELDSEN
Principal III
Apr 6, 2020 11:57 AM UTC

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

Martin KJELDSEN
Principal III
Apr 6, 2020 11:58 AM UTC

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
Apr 6, 2020 12:09 PM UTC

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.