Excel old XLS format vs. XML Spreadsheet format [1359]

Last post 11-11-2009, 3:59 PM by Chief_Apricot. 5 replies.
Sort Posts: Previous Next
  •  03-16-2008, 1:01 PM 6815

    Excel old XLS format vs. XML Spreadsheet format [1359]

    Current behavior:
    Wild Apricot uses XML Spreadsheet format for import and export. It can be opened in MS Excel 2003 and higher or Excel for Mac 2004 or higher. It also can be opened in some free Office software like StarOffice.

    Desired behavior:
    Using 'old' XLS format instead to be compatible with old version of Microsoft Excel and other spreadsheet software.
    Dmitry Buterin, Chief Apricot
    Filed under:
  •  03-17-2008, 1:10 PM 5270 in reply to 6815

    Make membership spreadsheet compatible with older versions of Excel

    Hi, I am only able to download the member database spreadsheet when I use a computer with Excel 2003.  Is it possible to make it work with older versions of Excel?  Thanks.

     Bernadette


    Origins-USA.org: Protecting the natural right of mothers to nurture their children
  •  03-21-2008, 10:13 AM 5434 in reply to 6815

    • Vassily is not online. Last active: 01-27-2010, 9:13 AM Vassily
    • Top 25 Contributor
    • Joined on 03-03-2008
    • Posts 69
    • WA staff

    Re: Make membership spreadsheet compatible with older versions of Excel

    Hello,

    Now there is no way to display the exported spreadsheet in earlier Excel versions (only by saving it in version 2003 and later) but we plan to implement other formats for export and import in the future.


    Vassily, Wild Apricot team
  •  03-21-2008, 11:43 PM 5453 in reply to 6815

    • clarus is not online. Last active: 02-22-2009, 10:34 PM clarus
    • Top 150 Contributor
    • Joined on 01-15-2008
    • Posts 6

    Re: Make membership spreadsheet compatible with older versions of Excel

    If you do not own Excel 2003, you may open the file the latest version of OpenOffice (http://www.OpenOffice.org).  It is possible to re-save the file in older Excel formats.

     

    BernadetteMW:

    Hi, I am only able to download the member database spreadsheet when I use a computer with Excel 2003.  Is it possible to make it work with older versions of Excel?  Thanks.

     Bernadette

  •  06-18-2009, 11:45 AM 13143 in reply to 5453

    • Gordon is not online. Last active: 03-12-2010, 10:33 AM Gordon
    • Top 25 Contributor
    • Joined on 11-17-2007
    • Posts 144

    Why use XML?

    It would be great if we could get away from having to use XML for all import/export.

    I can understand why it simplifies processing on your end but the requirement to have a fairly recent version of Excel is a significant obsticle.  There are many cheap or free spreadsheet tools available which would bypass the need for Excel. 

    A simple csv or tab delimited text file that can be imported into any spreadsheet program would be a valuable enhancement. 

    Gordon

  •  11-11-2009, 3:59 PM 15094 in reply to 6815

    Re: Excel old XLS format vs. XML Spreadsheet format [1359]

    FYI everyone - we are working on a redesign of our import function which among other things should remove the requirement to use Xml spreadsheet format.

    Dmitry Buterin, Chief Apricot
View as RSS news feed in XML