Comments (6)
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?
from advanced-formula-environment.
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.
from advanced-formula-environment.
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.
from advanced-formula-environment.
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.
from advanced-formula-environment.
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.
from advanced-formula-environment.
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.
from advanced-formula-environment.
Related Issues (20)
- Non-english array notation HOT 6
- Allow user to specify the tab length
- No way to share functions written using Names>Functions tab HOT 7
- How timer LAMBDA function works from Lib.md? HOT 4
- Dot in function name in Workbook is allowed but not in any other module HOT 2
- Comments in the Grid tab HOT 4
- Format doesn't work with selected text for Modules HOT 1
- Failed to load HOT 1
- Editor doesn't recognize valid Script Lab custom functions HOT 1
- Synchronization of shared Modules HOT 2
- Feature request: edit Python HOT 2
- Module names with numeric characters HOT 3
- Import module from Name Manager HOT 1
- Function names starting with underscore HOT 2
- How to get detailed error messages HOT 1
- Allow import of raw content HOT 4
- Offline Use
- Support: What is the comment syntax? HOT 1
- Providing function descriptions in Module HOT 2
- Text copy and paste HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from advanced-formula-environment.