Hi i'm unable to get cell's value from my sheetnode in views.

I think im following the instructions for "How to spreadsheet viwes" correctly but no luck retrieving the value.

Add new view - Show: Content - Of type: Statistics (my node where i use sheednode)
Display format - Spreadsheet

Add fields - Sheetnode: Cell
This is where im stuck i have tried all i could find for the cell reference =C10, C10, ="NID"!C10 but nothing shows the cells value in views.

I think im mising something obvious but i can't find any info on google.

Thanks
David

Comments

arruk’s picture

arruk CreditAttribution: arruk commented
Issue summary: View changes

I just had the same problem, your cell references need to be capital letters like A1 not a1. Hope this helps you.

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented

Typically, "Sheetnode: Cell" is used in non-Spreadsheet views to access the cell of a Sheetnode or other node with a Sheetfield.

If you want to create a Spreadsheet view, then you can simply enter a "=C10" in a cell of your template.

Hope this helps.

willhallonline’s picture

willhallonline
Primary language English
Location Cambridge, UK
CreditAttribution: willhallonline as a volunteer commented
Status: Active » Closed (works as designed)

Closed as is resolved.