{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3]]}
["Parameter",null,"sbGetCell"]
["Number","Text style","Sample Input","Sample Result","Explanation"]
[1,"AbsReference",null,{"$f":"sbGetCell(C3,B3)","v":"$C$3"},"Absolute reference of the upper-left cell in reference, as text in the current workspace reference style"]
[2,"RowNumber",null,{"$f":"sbGetCell(C4,B4)","v":4},"Row number of the top cell in reference"]
[3,"ColumnNumber",null,{"$f":"sbGetCell(C5,B5)","v":3},"Column number of the leftmost cell in reference"]
[4,"Type","Text",{"$f":"sbGetCell(C6,B6)","v":2},"Same as TYPE(reference): 1=Number, 2=Text, 4=Boolean, 16=Error, 64=Array"]
[5,"Contents",{"$f":"PI()","v":3.1415926535897931},{"$f":"sbGetCell(C7,B7)","v":3.1415926535897931},"Contents of reference"]
[6,"FormulaLocal, ShowFormula",{"$f":"PI()","v":3.1415926535897931},{"$f":"sbGetCell(C8,A8)","v":"=PI()"},"Formula in reference, as text, in either A1 or R1C1 style depending on the workspace setting"]
[7,"NumberFormat",-3,{"$f":"sbGetCell(C9,B9)","v":"#.##0,00;[Rot]-#.##0,00"},"Number format of the cell, as text (for example, “m/d/yy” or “General”)"]
[8,"HorizontalAlignment","Center across selection",{"$f":"sbGetCell(C10,B10)","v":3},"Number indicating the cell’s horizontal alignment: 1=General, 2=Left, 3=Center, 4=Right, 5=Fill, 6=Justify, 7=Center across cells"]
[9,"LeftBorderStyle",null,{"$f":"sbGetCell(C11,B11)","v":7},"Number indicating the left-border style assigned to the cell: 0=None, 1=Thin, 2=Medium, 3=Dashed, 4=Dotted, 5=Thick, 6=Double, 7=Hair, 8 = MediumDashed, 9 = DashDot, 10 = MediumDashDot, 11 = DashDotDot, 12 = MediumDashDotDot, 13 = SlantDashDot"]
[10,"RightBorderStyle",null,{"$f":"sbGetCell(C12,B12)","v":10},"Number indicating the right-border style assigned to the cell: 0=None, 1=Thin, 2=Medium, 3=Dashed, 4=Dotted, 5=Thick, 6=Double, 7=Hair, 8 = MediumDashed, 9 = DashDot, 10 = MediumDashDot, 11 = DashDotDot, 12 = MediumDashDotDot, 13 = SlantDashDot"]
[11,"TopBorderStyle",null,{"$f":"sbGetCell(C13,B13)","v":0},"Number indicating the top-border style assigned to the cell: 0=None, 1=Thin, 2=Medium, 3=Dashed, 4=Dotted, 5=Thick, 6=Double, 7=Hair, 8 = MediumDashed, 9 = DashDot, 10 = MediumDashDot, 11 = DashDotDot, 12 = MediumDashDotDot, 13 = SlantDashDot"]
[12,"BottomBorderStyle",null,{"$f":"sbGetCell(C14,B14)","v":4},"Number indicating the bottom-border style assigned to the cell: 0=None, 1=Thin, 2=Medium, 3=Dashed, 4=Dotted, 5=Thick, 6=Double, 7=Hair, 8 = MediumDashed, 9 = DashDot, 10 = MediumDashDot, 11 = DashDotDot, 12 = MediumDashDotDot, 13 = SlantDashDot"]
[13,"Pattern",null,{"$f":"sbGetCell(C15,B15)","v":1},"Cell pattern, 0-18"]
[14,"IsLocked",null,{"$f":"sbGetCell(C16,B16)","v":true}]
[15,"HiddenFormula",{"$f":"PI()","v":3.1415926535897931},{"$f":"sbGetCell(C17,B17)","v":true}]
[16,"CellWidth",null,{"$f":"_xlfn.TEXTJOIN(\";\",TRUE,sbGetCell(C18,A18))","v":"20,57;FALSCH"},"Width and whether it changes with standard width, two item horizontal array"]
[17,"RowHeight",null,{"$f":"sbGetCell(C19,B19)","v":21}]
[18,"FontName",null,{"$f":"sbGetCell(C20,B20)","v":"Open Sans"}]
[19,"FontSize",null,{"$f":"sbGetCell(C21,B21)","v":14}]
[20,"IsBold","BOLD",{"$f":"sbGetCell(C22,B22)","v":true}]
[21,"IsItalic","ITALIC",{"$f":"sbGetCell(C23,B23)","v":true}]
[22,"IsUnderlined","underlined",{"$f":"sbGetCell(C24,B24)","v":true}]
[23,"IsStruckThrough","struck through",{"$f":"sbGetCell(C25,B25)","v":true}]
[24,"FontColorIndex",null,{"$f":"sbGetCell(C26,B26)","v":56},"Font color index of first character, 1-56, 0 if automatic"]
[25,"IsOutlined",null,{"$f":"sbGetCell(C27,B27)","v":false},"Not supported by MS Excel"]
[26,"IsShaddowed",null,{"$f":"sbGetCell(C28,B28)","v":false},"Not supported by MS Excel"]
[27,"PageBreak",null,{"$f":"sbGetCell(C29,B29)","v":0},"0 = no break, 1 = row, 2 = column, 3 = row and column"]
[28,"RowLevelOutline",null,{"$f":"sbGetCell(C30,B30)","v":1}]
[29,"ColumnLevelOutline",null,{"$f":"sbGetCell(C31,B31)","v":1}]
[30,"IsSummaryRow",null,{"$f":"sbGetCell(C32,B32)","v":false}]
[31,"IsSummaryColumn",null,{"$f":"sbGetCell(C33,B33)","v":false}]
[32,"WorkbookSheetName",null,{"$f":"sbGetCell(C34,B34)","v":"[sbgetcell.xlsm]Sheet1"},"Name of the sheet in the form “[Book1]Sheet1”, or BOOK1.XLS if single sheet has identical name as workbook"]
[33,"IsWrapped","This text is wrapped",{"$f":"sbGetCell(C35,B35)","v":true}]
[34,"LeftBorderColorIndex",null,{"$f":"sbGetCell(C36,B36)","v":-4142},"Left border color index"]
[35,"RightBorderColorIndex",null,{"$f":"sbGetCell(C37,B37)","v":-4142},"Right border color index"]
[36,"TopBorderColorIndex",null,{"$f":"sbGetCell(C38,B38)","v":-4142},"Top border color index"]
[37,"BottomBorderColorIndex",null,{"$f":"sbGetCell(C39,B39)","v":15},"Bottom border color index"]
[38,"ShadeForeGroundColor",null,{"$f":"sbGetCell(C40,B40)","v":-4105}]
[39,"ShadeBackGroundColor",null,{"$f":"sbGetCell(C41,B41)","v":2}]
[40,"TextStyle",null,{"$f":"sbGetCell(C42,B42)","v":"Standard"}]
[41,"FormulaWOT",{"$f":"LEFT(B43,4)","v":"Form"},{"$f":"sbGetCell(C43,B43)","v":"=LEFT(B43,4)"},"Formula without translation"]
[46,"HasNote",null,{"$f":"sbGetCell(C44,B44)","v":false},"Contains text note?"]
[47,"HasSound",null,{"$f":"sbGetCell(C45,B45)","v":false},"Not supported. Sound notes have been removed from MS Excel"]
[48,"HasFormula",{"$f":"PI()","v":3.1415926535897931},{"$f":"sbGetCell(C46,B46)","v":true},"If the cells contains a formula, returns TRUE; if a constant, returns FALSE"]
[49,"IsArray",null,{"$f":"sbGetCell(C47,B47)","v":false},"If the cell is part of an array, returns TRUE; otherwise, returns FALSE"]
[50,"VerticalAlignment",null,{"$f":"sbGetCell(C48,B48)","v":2},"1 = Top, 2 = Center, 3 = Bottom, 4 = Justified, 5 = Distributed"]
[51,"VerticalOrientation",null,{"$f":"sbGetCell(C49,B49)","v":0},"0 = Horizontal, 1 = Vertical, 2 = Upward, 3 = Downward"]
[52,"IsStringConstant","hello",{"$f":"sbGetCell(C50,B50)","v":"'"},"Returns apostrophe if input cell is a string constant"]
[53,"AsText",null,{"$f":"sbGetCell(C51,B51)","v":""},"Contents of the cell as it is currently displayed, as text, including any additional numbers or symbols resulting from the cell’s formatting"]
[54,"PivotTableViewName",null,{"$f":"sbGetCell(C52,B52)","v":{"$error":"#VALUE!"}},"Returns the name of the PivotTable view containing the active cell"]
[56,"PivotTableViewFieldName",null,{"$f":"sbGetCell(C53,B53)","v":{"$error":"#VALUE!"}},"Returns the name of the field containing the active cell reference if inside a PivotTable view"]
[57,"IsSuperscript","Superscript",{"$f":"sbGetCell(C54,B54)","v":true}]
[58,"FontStyleText",null,{"$f":"sbGetCell(C55,B55)","v":"Standard"},"Font style text of all styles in cell"]
[59,"UnderlineStyle","underlined",{"$f":"sbGetCell(C56,B56)","v":3},"1 = none, 2 = single, 3 = double, 4 = single accounting, 5 = double accounting"]
[60,"IsSubscript","Subscript",{"$f":"sbGetCell(C57,B57)","v":true}]
[61,"PivotTableItemName",null,{"$f":"sbGetCell(C58,B58)","v":{"$error":"#VALUE!"}},"For demonstration purposes referring to cell B86"]
[62,"WorksheetName",null,{"$f":"sbGetCell(C59,B59)","v":"[sbgetcell.xlsm]Sheet1"},"Worksheet name like [Book1.xls]Sheet1"]
[65,"IsAddIndentAlignment",null,{"$f":"sbGetCell(C60,B60)","v":false},"Not supported"]
[66,"WorkbookName",null,{"$f":"sbGetCell(C61,B61)","v":"sbgetcell.xlsm"},"Book name of the workbook containing the cell in the form BOOK1.XLS"]