Grid edit formula bug

[ammosov]

Start with:

Editing to -

Returning to normal edit mode

Going to formula edit mode:

UNDO is not available. Copy and paste restores back to original state OK. Entering the very same syntax by hand works normally.

[jack-williams]

Just to confirm my understanding: the issue is that the function arguments box is not displaying the formulas for the arguments? The expected behavior is for the MEDIAN formula to appear there?

[ammosov]

I would say, the formula in the cell is expected to remain visible and editable using either of the methods - conventional Excel and AFE grid editor. It appears that once edited with AFE, it becomes editable only as AFE object, and somehow obfuscated or otherwise becomes uneditable in basic edit way.

[ammosov]

UPD. I discovered by trial and error that the formula is still there in Basic Edit Mode but all spaces are passed to it too. So you can edit it but you cannot see more than a few letters at once - a function name, an argument or any other part of it on one line in AFE editor.

[jack-williams]

The underlying behavior causing the problem is that we emit the formula with line-breaks. You can expand the formula bar to see the full formula:

That being said, I can see how that is still undesirable and the preferred behavior is to emit on a single line. We are tracking this in #28.

Regarding the specific issue of the Function Arguments dialog, I believe this is an issue with Excel and not AFE. If I create a multi-line formula in a workbook without AFE, such as:

=SUM(
1,
2
)

and open the insert function box, I similarly see no arguments. EDIT as I have also discovered, it is there but hidden!

I hope that by saving the formulas in the cell as a single line this will solve the problem.

[ammosov]

Yes, this seems to be what I discovered, too. Otherwise, AFE would be my preferred edit more from now on. It would be nice if extra spaces/line breaks were trimmed for basic edit more and restored for AFE mode.

[jack-williams]

Great, I'll close this issue as a duplicate of #28. When that is closed, I expect the behavior will be:

• Default: Break lines to fit within AFE. Save to cell on single line.
• Add option to preserve formatting between cell and AFE.