Hi :) CSV is basically a text-file and doesn't have the capability of storing info about different sheets. It is a limit of the format. Each sheet can be a separate CSV file. That is one advantage that spreadsheet formats such as ods or xls give. They take up extra space because they contain a greater level of sophistication.
Csv is good for transfer between incompatible programs. One of which is almost invariably a proprietary program because OpenSource programs aim at being able to exchange data easily. Proprietary programs almost invariably make a deliberate effort to stop their data being able to be used by other programs in any easy way. People are then forced to buy the proprietary program in order to be able to work with their data. Hence all the problems with .docX and .xlsX and all the people making demands for wider-spread adoption of Open Documents standards. LO does have a format that handles many sheets within a workbook, ods. It 'should' be smaller and lighter than xls but it is unlikely to be used by proprietary devices or proprietary programs. MS Office has been forced into allowing Open Document Formats but it makes sure it handls them badly so that people are forced into using their proprietary ones instead. The whole point about Csv is that it's a very very simplistic, very light-weight format. Regards from Tom :) ________________________________ From: Robert Prins <[email protected]> To: [email protected] Sent: Tue, 3 May, 2011 8:16:20 Subject: [libreoffice-users] Added feature request Hi all, One of the things that is asked for repeatedly on z/OS related forums is the ability to create, on that platform, multi-sheet spreadsheets in CSV format for import on the PC into LO (or that other product), with the standard answer that it isn't possible to create multi-sheet spreadsheets from CSV. Wouldn't it be great if LO could distinguish itself if you added an option to actually make this possible? Robert -- Robert AH Prins [email protected] -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
