Custom number formats are not properly implemented

[ryba-xek]

Custom number formats are not implemented

http://www.openoffice.org/sc/excelfileformat.pdf page 174

i use github.com/IntelligenceX/fileconversion/xls which contain a number of fixes, but still formats like '0"руб."' do not work well.

Here is my patched func (xf *XfRk) String(wb *WorkBook) from col.go

func (xf *XfRk) String(wb *WorkBook) string {
	idx := int(xf.Index)
	if len(wb.Xfs) > idx {
		fNo := wb.Xfs[idx].formatNo()
		if fNo >= 164 { // user defined format
			if formatter := wb.Formats[fNo]; formatter != nil {
				formatterLower := strings.ToLower(formatter.str)
				if formatterLower == "general" ||
					strings.Contains(formatter.str, "#") ||
					strings.Contains(formatter.str, ".00") ||
					strings.Contains(formatterLower, "m/y") ||
					strings.Contains(formatterLower, "d/y") ||
					strings.Contains(formatterLower, "m.y") ||
					strings.Contains(formatterLower, "d.y") ||
					strings.Contains(formatterLower, "h:") ||
					strings.Contains(formatterLower, "д.г") {
					//If format contains # or .00 then this is a number
					return xf.Rk.String()
				} else {
					// http://www.openoffice.org/sc/excelfileformat.pdf page 174
					var res []string
					parts := strings.Split(formatter.str, "\"")
					var inString bool
					for _, part := range parts {
						if inString {
							res = append(res, part)
						} else {
							switch part {
							case "":
								res = append(res, part)

							case "0": // Decimal
								i, f, isFloat := xf.Rk.number()
								if isFloat {
									res = append(res, fmt.Sprintf("%.f", f)) // convert float to decimal
								} else {
									res = append(res, strconv.FormatInt(i, 10))
								}

							default:
								panic(fmt.Sprintf("Unknown formater: '%s'", part))
							}
						}
						inString = !inString
					}
					return strings.Join(res, "")

					//i, f, isFloat := xf.Rk.number()
					//if !isFloat {
					//	f = float64(i)
					//}
					//t := timeFromExcelTime(f, wb.dateMode == 1)
					//
					//return yymmdd.Format(t, formatter.str)
				}
			}
			// see http://www.openoffice.org/sc/excelfileformat.pdf Page #174
		} else if 14 <= fNo && fNo <= 17 || fNo == 22 || 27 <= fNo && fNo <= 36 || 50 <= fNo && fNo <= 58 { // jp. date format
			i, f, isFloat := xf.Rk.number()
			if !isFloat {
				f = float64(i)
			}
			t := timeFromExcelTime(f, wb.dateMode == 1)
			return t.Format(time.RFC3339) //TODO it should be international
		}
	}
	return xf.Rk.String()
}