Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature request: insert column title instead of cell name when typing a formula #334

Open
sh-ravan opened this issue Aug 20, 2024 · 2 comments
Labels
enhancement New feature or request

Comments

@sh-ravan
Copy link

sh-ravan commented Aug 20, 2024

Please consider implementing a feature that allows us to insert column title instead of cell name when typing a formula.

For example, when clicking on cell A3, instead of seeing 'A3' in the formula editor, we would like to have '@quantity' inserted.
So, instead of this,
image
we'd like to be able to do this.
image

Ideally, we want to control the auto-fill behaviour programmatically and ensure that when a column title is used in a formula, any changes to the title are automatically reflected in the formula.

@hodeware
Copy link
Contributor

hodeware commented Aug 20, 2024

This is already available using Formula Pro. The autocomplete will be consider in future releases.


// Create spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
    worksheets: [{
        data: [
            [ 10, '=@Quantity*10' ],
            [ 20, '=@Quantity*10' ],
            [ 30, '=@Quantity*10' ],
        ],
        columns: [
            { type: 'text', width:'300', title: 'Quantity' },
            { type: 'text', width:'200', title: 'Total' },
        ]
    }],
    columnNamesInFormulas: true,
});

@hodeware hodeware added the enhancement New feature or request label Aug 20, 2024
@sh-ravan
Copy link
Author

sh-ravan commented Aug 21, 2024

Thanks, I am using the formula pro extension like you mentioned in the snippet. The request is for the autocomplete feature.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants