Project

General

Profile

Actions
Copy link

Bug #3355

closed

Formulas don't work with Excel Data Sources

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

Status:
Resolved
Priority:
Normal
Assignee:
Ryan McFall
Category:
client
Target version:
Unspecified
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.

Actions
Copy link
 #1

Updated by Ryan McFall over 16 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.

Actions
Copy link
 #2

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 3355

Actions
Copy link

Also available in: Atom PDF