Project

General

Profile

Bug #3355

Formulas don't work with Excel Data Sources

Added by Ryan McFall over 11 years ago. Updated over 11 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
client
Target version:
Start date:
06/03/2008
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
3355

Description

If a cell contains a formula in an Excel spreadsheet, the DataSourcePreviewPanel just displays an empty column.

This is because there's a case statement in the TableModel that doesn't handle the type of cell associated with formulas.

History

#1 Updated by Ryan McFall over 11 years ago

Fixed by implementing code in POIExcelDataSource getCellValue to handle formulas. Note that there are limitations to the formula evaluating capabilities of the POI model, but most things are supported, so we should be OK.

#2 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 3355

Also available in: Atom PDF