Spreadsheet displays link warning and values get corrupted when inserting rows

Desktop editors
,
1

test7 b2.xlsx (14.8 KB)

This spreadsheet has the following issues:

  1. When I open the spreadsheet, the warning appears, but the link is not found.

    image
    image494×192 4.98 KB

  2. If I insert a row above the last row, the values in the last row will be “#NUM!”.

    image
    image759×151 13 KB

  3. After I overwrite and close the spreadsheet, If I reopen it then the values in previous rows will be “#N/A”.

    image
    image779×155 14.5 KB

I use desktop editors 9.0.4.50 (x64 exe).

2

Hello @nishigaki

Apparently there is 1, or it was there:

image
image1068×692 33.4 KB

This is just a visual quirk, but will take a closer look at it.

I was unable to reproduce this one. Do you open attached spreadsheet locally from the device or your Desktop Editors are connected to DocSpace cloud and file originally stored there?

4

Hello @Constantine

About external link warning.
In Excel, since the link does not exist in any cell, it does not appear in the external links list and cannot be deleted. On the other hand, in desktop editors, is it the specification that links not referenced from a cell are displayed?

About “#NUM!” and “#N/A”.
I opened the spreadsheet from the local device.
This is the recording. ONLYOFFICE

5

Possibly we are using different versions of MS Excel for tests, but I can see the link there too:

image
image394×146 3.05 KB

Thanks for the video. Unfortunately, performing the exact same steps did not produce the issue with #N/A in my case. In one of your other topics I’ve suggested to reinstall Desktop Editors with the MSI installer for Windows 11, did you have a chance to do that? Is this screen recording made after the reinstallation?

6

Hello @Constantine

I use MS excel 2019(japanese), I can’t click a edit links button. Is this a problem with my MS Excel?

image
image542×336 16 KB

I’ll try the msi installer once I’ve finished testing the other issue.
However, when I tried this in Docs, adding a row displayed “#NUM!” and “#N/A.” ONLYOFFICE

7

Unfortunately, I do not know. It works for me with Excel from Microsoft 365 MSO (Version 2508 Build 16.0.19127.20192).

We keep checking the issue.

8

Hello @Constantine

Since it works in newer versions of Excel, I believe this is a change in Excel’s specifications and the warning issue is resolved.

1 Like
9

Hello @Constantine

I tried the msi installer, but No.2 and No.3 problem is occurred.

10

Thanks for the reply. We continue analysis, I’ll let you know if we require any further information from your side.

UPD: I was informed that this behavior has been registered as a bug.

12

Hello @Constantine

I look forward to the fix.
In Docs too.

13

We have just released version 9.1 of the editors. Update for ONLYOFFICE Docs is available already, but for Desktop Editors it will be published a bit later.

Please await the update and check the situation again.

14

Thanks @Constantine

I tried 9.1.0.167 (x64 exe) from ONLYOFFICE desktop and mobile apps | ONLYOFFICE.
No.3 is solved! but No.2 still occur.

DocSpace Cloud is currently at v9.0.4, so the situation is the same.
ONLYOFFICE DocSpace v.3.2.1
ONLYOFFICE Docs v.9.0.4.50

16

Thank you for the feedback. We keep working on it.

Sorry for the inconvenience.

17

@nishigaki, we have updated editors in DocSpace to the version 9.2 and the issue number 2 – last row displays #N/A after inserting a row above – has been fixed. Please check it out and share a feedback.

NB: Desktop Editors will be updated shortly.

18

Thanks! @Constantine

I was able to check it in DocSpace. I’ll wait for the Desktop Editors to update.

19

Update for Desktop Editors has been released. You can update and check out the situation there too.

20

Thanks! @Constantine

I checked it out. It’s solved.

1 Like