Loading...
 
Features / Usability

Features / Usability


Re: tiki sheets cross sheet referencing

posts: 143 United States

When Tiki branches we do our best to ensure that the branch stabalizes, but it is hard to line everything for 3rd party packages. This is one of those very odd cases, and 8.3 (and more specifically jQuery.sheet) has a totally new system built in for ensuring that those formulas work. The correct syntax is upper-case selectors and functions...

Copy to clipboard
=SHEET2!A1


should work fine to look at the second sheet attached to the current sheet.

Copy to clipboard
=sheet2!a1


I don't think will.

Also, some of the syntax was in flux at that time, you might try this:

Copy to clipboard
=SHEET2:A1


Notize the ":" rather than the "!" , which we changed to later to be more compliant with spreadsheet standards.

There are no comments at this time.