Giter VIP home page Giter VIP logo

Comments (5)

rruhle avatar rruhle commented on June 6, 2024

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.

rruhle avatar rruhle commented on June 6, 2024

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.

taviso avatar taviso commented on June 6, 2024

Here is what I mean:

  1. Create a named range, say D1..D5 and call it TEST.
  2. Go to A1 and enter +, then move the pointer to D1, press ., then highlight D1..D5.
  3. 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.

rruhle avatar rruhle commented on June 6, 2024

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:

Clip2

Clip1

Clip 1 show top left status bar with "TEST" showing as range name, and actual cell address below

from 123elf.

taviso avatar taviso commented on June 6, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.