Two types of problems occur when entering a cross-spreadsheet reference formula

Desktop editors
1

Two types of problems occur when entering a cross-spreadsheet reference formula.

I use
desktop editors 9.1.0.167 (x64 exe)
windows 11 pro 24H2

video ONLYOFFICE

0:00 Create two new spreadsheets
0:14 Entering a cross-spreadsheet reference formula → Unable to complete
0:34 Save one spreadsheet
0:46 Entering a cross-spreadsheet reference formula → Unable to complete
0:56 Save another spreadsheet
1:07 Entering a cross-spreadsheet reference formula → Success
1:24 Entering a cross-spreadsheet reference formula → Invalid workbook name specified

2

Hello @nishigaki

I may assume the issues are:

  1. Unable to use referenced cells before saving of both files;
  2. #REF! appearing.

For the first one: it is expected, because newly created files do not exist in the file system and the changes made to them are not saved, so the values for referencing do not exist at this moment.

Second one, if I get it right, is a bit unclear. What exact actions you do at 1:27 mark? I can see that the formula editor is opened, but the formula only contains = sign, while it should have the reference link. Can you share more detailed steps?

3

Hello @Constantine

Supplement the report.

0:00 Create two new spreadsheets
0:14 Entering a cross-spreadsheet reference formula → Unable to complete

-> I can complete the formula in MS Excel.

0:34 Save one spreadsheet
0:46 Entering a cross-spreadsheet reference formula → Unable to complete

-> The values for referencing exist in e.xlsx.

0:56 Save another spreadsheet
1:07 Entering a cross-spreadsheet reference formula → Success
1:24 Entering a cross-spreadsheet reference formula → Invalid workbook name specified

-> I selected '[e.xlsx]シート1'!$B$2, but '[ブック6.xlsx]シート1'!$B$2 was set.

The question at 1:27 is whether the formula “=‘[e.xlsx]シート1’!$B$2” becomes “=”? When I select the tab “e.xlsx”, the formula becomes “=”.

4

I see, so this is issue number 1.

I am not following this question. Do you use any keys, for instance, to edit the cell at that moment? I my tests it produces different behavior – the formula still contains a reference link.

5

Hello @Constantine

I’m doing the following:
1:27 I type F2 key to edit cell.
1:30 click “e.xlsx” tab.
1:33 click “B2” cell.

6

I see, thank you. We’re checking this behavior, please await my feedback.

8

So the issue with #REF! is a bug, it has been registered.

However, the first problem, which is the inability to use reference links to an unsaved file, is expected. As I mentioned, newly created file does not exist in the file system, thus there is nowhere to build a reference to.

9

Thanks @Constantine

I look forward to the #REF! issue being resolved.

I also have understood the requirements for reference links.
However, since MS Office allows to create links between unsaved files, those familiar with MS Office may not understand this symptom. I’m not sure how to make them understand the symptom, though.

1 Like
10

It is possible that a warning would be added to ensure that, but thats for the future updates.

11

Thanks @Constantine

Yes, it’s difficult to find a method that works for everyone.

1 Like