Comments (5)
OK, I tried but can't duplicate.
If the F5 key is POINT mode, any Name entered will goto first cell address in that named range, but adding F3 key disables spreadsheet pointer to focus on status bar list of names, displayed in alphabetical order regardless of cell selected in spreadsheet.
from 123elf.
If spreadsheet function status bar won't be similar in Linux & DOS, then @cell(Name, D6) will certainly help.
Management of range names in modern spreadsheets use menu selections & tables to list data or range names, before clicking Edit, Delete, or Rename.
123 menus must select / Range / Name / (Create or Delete) before selecting a Name or typing an address from memory. So, using F5 to point to range address is highly recommended before executing these actions.
from 123elf.
Here is what I mean:
- Create a named range, say
D1..D5
and call itTEST
. - Go to A1 and enter +, then move the pointer to
D1
, press ., then highlightD1..D5
. - Now press F3 and it should know you wanted
TEST
. This works on any named range.
How did @@()
work, it should be possible to add it! Can you give me example steps, or point me to the manual page about it?
from 123elf.
Never saw that before, Thanks. Works for ranges > 1 cell, if empty column exist on left.
My only V.2 documentation for @@() function is screen shots:
Clip 1 show top left status bar with "TEST" showing as range name, and actual cell address below
from 123elf.
Ahh, I see what you mean! Hmm, okay, let me look at the code and see if maybe we can add this.
I think maybe a new attribute might work too, but I'll take a look!
from 123elf.
Related Issues (20)
- Investigate SIGWINCH handler HOT 4
- Macro / step not visible HOT 6
- BREAK Function & NUM Indicator are Disabled HOT 3
- Exploitable Stack Overflow HOT 6
- Add LICENSE HOT 3
- Segmentation fault (core dumped) HOT 5
- 'Ctrl-Z' Forces Exit to terminal losing all data HOT 6
- Exiting graph display from within a macro HOT 3
- Adding a Data Legend can mess up the graph display. HOT 1
- Math Error HOT 9
- Wiki: How to enter a formula that starts with a cell reference? HOT 2
- lotus123r3_1.0-4bionic_i386.deb does not install on 32bit system HOT 1
- Installation gets errors while extracting files HOT 6
- PIC files? HOT 4
- Appreciation; signal handling issues; typo in linux/unix flags translation? HOT 8
- Not a source port?
- Linux Debian 12 Bookworm Launched
- Make /File Import use a larger buffer
- Not working in fbterm HOT 2
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 123elf.