OSBI/saiku — Issue #29: Export to excel: numbers stored as text
Author: buggtb
Created: 2011-10-11 14:57:21+00:00
State: open

When I export a saiku result set to excel, the numeric values in the .xls file are somehow stored incorrectly; excel says they are "number stored as text" and if I try to, say, do a sum(range) in excel, the answer is "zero".

Example excel export (with malfunctioning range sum) is attached.

Cheers,

Tyler