<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
I have only a few sessions and observations entered (2 sessions and 3 observations in all)<br>The xls is exported, but I can't open it with Open Office Calc<br>However if I export all selected observations as a text file, all observation data is there. The only way I can get the observation data out is by Ctrl+c and paste them in OO Calc (sorting on the date gives me a nice table)<br><br>I hope that that will be a useful workaround for now<br>Clear Skies!<br>Inge<br><br>> From: astronomy@clearskies.nl<br>> To: apbeta@lists.astroplanner.net<br>> Date: Mon, 5 Oct 2009 01:05:36 +0200<br>> Subject: Re: [APBeta] Exporting a session to Excel<br>> <br>> When I export the small session that will actually export, Excel tells me<br>> the file is not in the .xls format, although it will open. Also, all data is<br>> there except the notes of the actual observations in the session.<br>> <br>> Victor van Wulfen<br>> <br>> <br>> www.clearskies.eu<br>> <br>> <br>> > -----Oorspronkelijk bericht-----<br>> > Van: apbeta-bounces@lists.astroplanner.net [mailto:apbeta-<br>> > bounces@lists.astroplanner.net] Namens Paul Rodman<br>> > Verzonden: maandag 5 oktober 2009 0:52<br>> > Aan: AstroPlanner Beta Testers<br>> > Onderwerp: Re: [APBeta] Exporting a session to Excel<br>> > <br>> > <br>> > On Oct 4, 2009, at 1:42 PM, Victor van Wulfen wrote:<br>> > <br>> > >><br>> > >> Do you get a dialog asking about consolidating observations, etc.<br>> > >> immediately after File->Export->Excel File... ?<br>> > ><br>> > > Nope, nothing...<br>> > <br>> > I can't reproduce this on Mac or Windows.<br>> > <br>> > What I do is:<br>> > <br>> > a. Open the Observation database window (Observation->Show Observation<br>> > Database).<br>> > b. Select a session in the left list<br>> > c. File->Export->Excel File...<br>> > d. In the Choose Export Mode dialog, I select the default radio button<br>> > (All visible observations)<br>> > e. Click OK, select a place to save the file, and bingo.<br>> > <br>> > You're saying that the app grinds to a halt between steps (c) and (d)?<br>> > <br>> > <br>> > Paul R.<br>> > <br>> > _______________________________________________<br>> > APBeta mailing list<br>> > APBeta@lists.astroplanner.net<br>> > http://lists.astroplanner.net/listinfo.cgi/apbeta-astroplanner.net<br>> <br>> <br>> _______________________________________________<br>> APBeta mailing list<br>> APBeta@lists.astroplanner.net<br>> http://lists.astroplanner.net/listinfo.cgi/apbeta-astroplanner.net<br> <br /><hr />SMS "vrienden" naar 3010 en ontvang gratis de juiste instellingen voor <a href='http://www.microsoft.com/netherlands/windowslive/Views/productdetail.aspx?product=Mobile' target='_new'>Hotmail en Messenger op je mobiele telefoon</a></body>
</html>