LibreOffice

[agantuk]

So as I understand, there are about 10 rows of XML, which you copy paste AS IS into Excel. And when you do that, it crashes. Correct?

 

[Jaymin]

Nope. There is an XML of around 20,000 lines, which I "Open with excel". I apply certain formulae by adding new columns to it.Next I extract data from ledger and apply certain filters, post which there are around 10,000 odd lines of data. That has to be pasted below the data which imported from XML.

 

[Sushubh]

xml code is not in tabular form right? i have no idea why you would try to open an xml file in excel.

 

[Jaymin]

It can be opened with Excel. Everyone does that. And it imports data in some format whereby if u put a formula in 1 cell, it gets replicated automatically for the whole column. And it gets replicated for any data that is added just below the table as well.

 

[Sushubh]

i guess i do not know about xml files much then. unless excel is rendering xml files into tabular format. that would be a totally different case. i mean xlsx files are essentially xml files.

 

[Deleted member 7160]

Hope I understood correctly, Are you opening the XML file with excel? If yes, then next time instead of opening the file directly with excel, Import the XML file into excel. Try this and post your results here.



Also, to reduce the file size of the excel - Try saving the excel as Excel Binary workbook.

 

[Jaymin]

Ok, thanks! Will try out this option. Hope it helps! But i have a question on Binary workbook.....will i be still, be able to save the Pivots & the formulae that have been applied if i save it as a Binary workbook?

 

[Sushubh]

.xls should support almost everything that .xlsx support

 

[Jaymin]

I dont think so. As it doesnt save certain types of Pivots that i use. And i have seen that when i have saved that spreadsheet as .xlsI create the table, and save it. That very moment it gives me the message that certain features will not be saved if i choose the current format for saving. If i disregard the message & go ahead, i lose that Pivot when i re-open the file!I dont understand what is that particular thing which cant be saved in .xls......since even i know that .xls did have the support for Pivots!

 

[Sushubh]

xls was the official file format for older office systems. they migrated to xlsx with o2k7. they cannot add features to older file systems because it would break interoperability with older office editions. so i guess you are indeed using features which are specific to o2k7 and o2k10!