[Problem] Spreadsheet: Auto-completion doesn't work when referencing external spreadsheet as a link

[vasik12]

Is there an existing issue for this?

• I have searched the existing issues

Problem description

When external spreadsheet it is in project, link value to this sheet in the Formula Editor, is not show in the content menu (help) with spreadsheet alias.
If a project contains the spreadsheet directly there're for offer.

Full version info

OS: Windows 11 build 22000
Word size of FreeCAD: 64-bit
Version: 0.21.2.33771 (Git)
Build type: Release
Branch: releases/FreeCAD-0-21
Hash: b9bfa5c5507506e4515816414cd27f4851d00489
Python 3.8.10, Qt 5.15.2, Coin 4.0.1, Vtk 8.2.0, OCC 7.6.3
Locale: Czech/Czech Republic (cs_CZ)
Installed mods: 
  * A2plus 0.4.60n
  * CurvedShapes 1.0.4
  * Curves 0.6.13
  * Defeaturing 1.2.1
  * freecad.gears 1.0.0
  * Help 1.0.3
  * lattice2 1.0.0
  * Lithophane
  * Manipulator 1.5.0
  * QuickMeasure 2022.10.28

Subproject(s) affected?

None

Anything else?

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[Roy-043]

You have created a link to the external spreadsheet I think. Auto-completion does work if you use this pattern: externalFileName#spreadsheetName.aliasName.

[furgo16]

I too found out that autocompletion does not work if a spreadsheet is added as a link. Here's what I observed on this forum post.

It would be great for this to work, as adding a link to the spreadsheet is more flexible and convenient than associating the external spreadsheet by the externalFileName syntax.

[luzpaz]

@vasik12 @furgo16 can you attach a screencast of this occurring ?

[furgo16]

@luzpaz sure, here it is:

Autocomplete.webm

Note how autocompletion does not work on the linked spreadsheet, yet the external reference is recognized as soon as it's fully typed.

I'd also suggest to change the title of this issue:

- [Problem] Spreadsheet: Auto-completion doesn't work when referencing external spreadsheet
+ [Problem] Spreadsheet: Auto-completion doesn't work when referencing external spreadsheet as a link