search

Iwark / spreadsheet

Google Go (golang) library for reading and writing spreadsheet files on Google Docs.
MIT License
382 stars 53 forks source link

cannot get cell raw data only formatted value #47

Closed eldadts closed 2 years ago

eldadts commented 4 years ago

In all the data that I get I only get the formatted value - all the rest are constantly empty, while I need the raw data:

(spreadsheet.CellData) {
   UserEnteredValue: (spreadsheet.ExtendedValue) {
    NumberValue: (float64) 0,
    StringValue: (string) "",
    BoolValue: (bool) false,
    FormulaValue: (string) "",
    ErrorValue: (spreadsheet.ErrorValue) {
     Type: (string) "",
     Message: (string) ""
    }
   },
   EffectiveValue: (spreadsheet.ExtendedValue) {
    NumberValue: (float64) 0,
    StringValue: (string) "",
    BoolValue: (bool) false,
    FormulaValue: (string) "",
    ErrorValue: (spreadsheet.ErrorValue) {
     Type: (string) "",
     Message: (string) ""
    }
   },
   FormattedValue: (string) (len=4) "2019",
   Hyperlink: (string) "",
   Note: (string) ""
  }
 }