Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Opening Excel .xls file with Charts in Calc

Hello,

I am researching Libre Office as an alternative to Microsoft Excel for my company.

We have a number of large Excel spreadsheets (.xls made in Excel 2000) that have 300+ worksheets and charts. We would like to be able to open them in Libre Office and edit them.

I can open the spreadsheets in Calc fine. However the charts created in Excel are not recognised as objects in Calc. They are only appearing as images which cannot be selected.

Is there any way of opening a .xls file with charts in Calc that gets Calc to: a) recognise the charts as actual charts b) lets you edit and update the charts

I would really like to not have to re-make over 600 charts in Calc!

Thanks very much,

Emma W

Opening Excel .xls file with Charts in Calc

Hello,

I am researching Libre Office as an alternative to Microsoft Excel for my company.

We have a number of large Excel spreadsheets (.xls made in Excel 2000) that have 300+ worksheets and charts. We would like to be able to open them in Libre Office and edit them.

I can open the spreadsheets in Calc fine. However the charts created in Excel are not recognised as objects in Calc. They are only appearing as images which cannot be selected.

Is there any way of opening a .xls file with charts in Calc that gets Calc to: a) recognise the charts as actual charts b) lets you edit and update the charts

I would really like to not have to re-make over 600 charts in Calc!

Thanks very much,

Emma W