|
| From: | Elias Tsolis |
| Subject: | Re: pspp-dev Digest, Vol 209, Issue 5 |
| Date: | Thu, 24 Mar 2022 10:05:36 +0200 |
Send pspp-dev mailing list submissions to
pspp-dev@gnu.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnu.org/mailman/listinfo/pspp-dev
or, via email, send a message with subject or body 'help' to
pspp-dev-request@gnu.org
You can reach the person managing the list at
pspp-dev-owner@gnu.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of pspp-dev digest..."
Today's Topics:
1. Re: pspp-dev Digest, Vol 209, Issue 4 (Elias Tsolis)
------------------------------------------------------------ ----------
Message: 1
Date: Thu, 24 Mar 2022 10:02:32 +0200
From: Elias Tsolis <estatisticseu@gmail.com>
To: "pspp-dev@gnu.org" <pspp-dev@gnu.org>
Subject: Re: pspp-dev Digest, Vol 209, Issue 4
Message-ID:
<CAN7+exzkQTe2Yp+wK4Tdovu3CSDJhwNraHuVcTxyYyWLVNZVww@mail.gmail.com">CAN7+exzkQTe2Yp+wK4Tdovu3CSDJhwNraHuVcTxyYyWLV NZVww@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
I can translate it in greek if you want.
Aldo i purpose to adf some examples for syntax.
Pkease tell me what to do.
On Wednesday, March 23, 2022, <pspp-dev-request@gnu.org> wrote:
> Send pspp-dev mailing list submissions to
> pspp-dev@gnu.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnu.org/mailman/listinfo/pspp-dev
> or, via email, send a message with subject or body 'help' to
> pspp-dev-request@gnu.org
>
> You can reach the person managing the list at
> pspp-dev-owner@gnu.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of pspp-dev digest..."
>
>
> Today's Topics:
>
> 1. Re: Your automagic screenshots! (Ben Pfaff)
> 2. Re: Your automagic screenshots! (John Darrington)
> 3. Re: Your automagic screenshots! (Ben Pfaff)
> 4. Re: Your automagic screenshots! (Alan Mead)
> 5. Re: Your automagic screenshots! (Ben Pfaff)
> 6. Re: Your automagic screenshots! (Friedrich Beckmann)
> 7. Re: Your automagic screenshots! (John Darrington)
>
>
> ------------------------------------------------------------ ----------
>
> Message: 1
> Date: Tue, 22 Mar 2022 09:20:50 -0700
> From: Ben Pfaff <blp@cs.stanford.edu>
> To: Friedrich Beckmann <friedrich.beckmann@gmx.de>
> Cc: John Darrington <john@darrington.wattle.id.au>, PSPP Development
> Mailing List <pspp-dev@gnu.org>
> Subject: Re: Your automagic screenshots!
> Message-ID:
> <CAA_G9+h5bPG70rk_5CT9vmLeJtrJdcrJQs13Fws0fSSu-
> 9GXKA@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> We've had documentation in French and Polish contributed by users
> before. We linked to it from the FAQ. It seems that those links are
> dead now, though.
>
> It would be great to get documentation contributions that we can
> include in the PSPP manual.
>
> On Tue, Mar 22, 2022 at 2:46 AM Friedrich Beckmann
> <friedrich.beckmann@gmx.de> wrote:
> >
> > Hi John,
> >
> > i just had a look at your automagic screenshots that you take for the
> documentation. Very nice. This Nina who asked on the mailing list
> >
> > https://lists.gnu.org/archive/html/pspp-users/2022-03/ msg00031.html
> >
> > how to import from Excel mentioned that it would be nice to have a
> description for this in the manual. I wanted to propose her that she could
> > make such a manual which would currently mean to write the texi code
> which would require to have a build system running to see the rendered
> pages. Automagic screenshots would be even more advanced.
> >
> > Did you ever propose users just to make some kind of handcrafted
> tutorial or documentation, provide it in pdf under some CC license and we
> would publish it on the gnu website?
> >
> > Cheers
> >
> > Fritz
> >
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 22 Mar 2022 19:23:57 +0100
> From: John Darrington <john@darrington.wattle.id.au>
> To: Friedrich Beckmann <friedrich.beckmann@gmx.de>
> Cc: John Darrington <john@darrington.wattle.id.au>, PSPP Development
> Mailing List <pspp-dev@gnu.org>
> Subject: Re: Your automagic screenshots!
> Message-ID: <YjoUPU8v7I56GDJ0@jocasta.intra>
> Content-Type: text/plain; charset=us-ascii
>
> So far as I'm aware, there's no way of importing directly from excel. You
> would
> first have to convert the excel file to something else like gnumeric or
> opendocument
> format.
>
> J'
>
> On Tue, Mar 22, 2022 at 10:45:32AM +0100, Friedrich Beckmann wrote:
> Hi John,
>
> i just had a look at your automagic screenshots that you take for the
> documentation. Very nice. This Nina who asked on the mailing list
>
> https://lists.gnu.org/archive/html/pspp-users/2022-03/ <msg00031.html
> https://lists.gnu.org/archive/html/pspp-users/2022-03/ >msg00031.html
>
> how to import from Excel mentioned that it would be nice to have a
> description for this in the manual. I wanted to propose her that she could
> make such a manual which would currently mean to write the texi code
> which would require to have a build system running to see the rendered
> pages. Automagic screenshots would be even more advanced.
>
> Did you ever propose users just to make some kind of handcrafted
> tutorial or documentation, provide it in pdf under some CC license and we
> would publish it on the gnu website?
>
> Cheers
>
> Fritz
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 22 Mar 2022 11:29:29 -0700
> From: Ben Pfaff <blp@cs.stanford.edu>
> To: John Darrington <john@darrington.wattle.id.au>
> Cc: Friedrich Beckmann <friedrich.beckmann@gmx.de>, PSPP Development
> Mailing List <pspp-dev@gnu.org>
> Subject: Re: Your automagic screenshots!
> Message-ID:
> <CAA_G9+hL=QTvRCqe=WnGx5oSuo9+fXGDhwmszS0Y1aP2TLS8cQ@mail.
> gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> It's an extraordinarily common feature request, so if there's a
> practical way to support direct import then we should consider it.
>
> On Tue, Mar 22, 2022 at 11:26 AM John Darrington
> <john@darrington.wattle.id.au> wrote:
> >
> > So far as I'm aware, there's no way of importing directly from excel.
> You would
> > first have to convert the excel file to something else like gnumeric or
> opendocument
> > format.
> >
> > J'
> >
> > On Tue, Mar 22, 2022 at 10:45:32AM +0100, Friedrich Beckmann wrote:
> > Hi John,
> >
> > i just had a look at your automagic screenshots that you take for
> the documentation. Very nice. This Nina who asked on the mailing list
> >
> > https://lists.gnu.org/archive/html/pspp-users/2022-03/ msg00031.html
> <https://lists.gnu.org/archive/html/pspp-users/2022- >03/msg00031.html
> >
> > how to import from Excel mentioned that it would be nice to have a
> description for this in the manual. I wanted to propose her that she could
> > make such a manual which would currently mean to write the texi
> code which would require to have a build system running to see the rendered
> pages. Automagic screenshots would be even more advanced.
> >
> > Did you ever propose users just to make some kind of handcrafted
> tutorial or documentation, provide it in pdf under some CC license and we
> would publish it on the gnu website?
> >
> > Cheers
> >
> > Fritz
> >
> >
>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 22 Mar 2022 13:40:57 -0500
> From: Alan Mead <amead2@alanmead.org>
> To: pspp-dev@gnu.org
> Subject: Re: Your automagic screenshots!
> Message-ID: <e3ca7111-8079-36b1-66b2-462308d5b24f@alanmead.org">e3ca7111-8079-36b1-66b2-462308d5b24f@alanmead.org>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> You are probably aware, but the XLSX format used in recent versions of
> Excel is significantly more accessible (it's a ZIP file containing XML
> and similar data) than the older XLS format.
>
> Also, it's fairly easy to open an XLS/XLSX file in LibreOffice and save
> it as CSV, but you can also use LO in a batch mode (Windows/DOS example):
>
> "C:\Program Files\LibreOffice\program\scalc.exe" --convert-to csv
> "excel_file.xls"
>
> produces "excel_file.csv" in CSV format.
>
> -Alan
>
> On 3/22/2022 1:29 PM, Ben Pfaff wrote:
> > It's an extraordinarily common feature request, so if there's a
> > practical way to support direct import then we should consider it.
> >
> > On Tue, Mar 22, 2022 at 11:26 AM John Darrington
> > <john@darrington.wattle.id.au> wrote:
> >> So far as I'm aware, there's no way of importing directly from excel.
> You would
> >> first have to convert the excel file to something else like gnumeric or
> opendocument
> >> format.
> >>
> >> J'
> >>
> >> On Tue, Mar 22, 2022 at 10:45:32AM +0100, Friedrich Beckmann wrote:
> >> Hi John,
> >>
> >> i just had a look at your automagic screenshots that you take for
> the documentation. Very nice. This Nina who asked on the mailing list
> >>
> >> https://lists.gnu.org/archive/html/pspp-users/2022-03/
> msg00031.html <https://lists.gnu.org/archive/html/pspp-users/2022-
> 03/msg00031.html>
> >>
> >> how to import from Excel mentioned that it would be nice to have
> a description for this in the manual. I wanted to propose her that she could
> >> make such a manual which would currently mean to write the texi
> code which would require to have a build system running to see the rendered
> pages. Automagic screenshots would be even more advanced.
> >>
> >> Did you ever propose users just to make some kind of handcrafted
> tutorial or documentation, provide it in pdf under some CC license and we
> would publish it on the gnu website?
> >>
> >> Cheers
> >>
> >> Fritz
> >>
> >>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 22 Mar 2022 11:47:15 -0700
> From: Ben Pfaff <blp@cs.stanford.edu>
> To: Alan Mead <amead2@alanmead.org>
> Cc: PSPP Development Mailing List <pspp-dev@gnu.org>
> Subject: Re: Your automagic screenshots!
> Message-ID:
> <CAA_G9+hvyXcOAazgY6qr7RV+-Zv01bfwW9qJP=jO2vRyEAEK2g@
> mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> I followed the saga of standardizing the XLSX format in some detail
> when it was going on 10 or so years ago. At least at the time, it was
> said that it would take a lot of work for a program to read it,
> because (for example) a program that read it would need to be able to
> implement recalculation, including all the formulas and functions,
> since the files didn't necessarily include the pre calculated values.
> This suggests to me that, if PSPP were to be able to read these files
> directly, then we would need to use a third-party library or program
> to do it with a reasonable amount of code.
>
> Maybe we should add instructions for conversion to the FAQ or the
> manual. The batch mode instructions look helpful to me.
>
> On Tue, Mar 22, 2022 at 11:41 AM Alan Mead <amead2@alanmead.org> wrote:
> >
> > You are probably aware, but the XLSX format used in recent versions of
> > Excel is significantly more accessible (it's a ZIP file containing XML
> > and similar data) than the older XLS format.
> >
> > Also, it's fairly easy to open an XLS/XLSX file in LibreOffice and save
> > it as CSV, but you can also use LO in a batch mode (Windows/DOS example):
> >
> > "C:\Program Files\LibreOffice\program\scalc.exe" --convert-to csv
> > "excel_file.xls"
> >
> > produces "excel_file.csv" in CSV format.
> >
> > -Alan
> >
> > On 3/22/2022 1:29 PM, Ben Pfaff wrote:
> > > It's an extraordinarily common feature request, so if there's a
> > > practical way to support direct import then we should consider it.
> > >
> > > On Tue, Mar 22, 2022 at 11:26 AM John Darrington
> > > <john@darrington.wattle.id.au> wrote:
> > >> So far as I'm aware, there's no way of importing directly from
> excel. You would
> > >> first have to convert the excel file to something else like gnumeric
> or opendocument
> > >> format.
> > >>
> > >> J'
> > >>
> > >> On Tue, Mar 22, 2022 at 10:45:32AM +0100, Friedrich Beckmann wrote:
> > >> Hi John,
> > >>
> > >> i just had a look at your automagic screenshots that you take
> for the documentation. Very nice. This Nina who asked on the mailing list
> > >>
> > >> https://lists.gnu.org/archive/html/pspp-users/2022-03/
> msg00031.html <https://lists.gnu.org/archive/html/pspp-users/2022-
> 03/msg00031.html>
> > >>
> > >> how to import from Excel mentioned that it would be nice to
> have a description for this in the manual. I wanted to propose her that she
> could
> > >> make such a manual which would currently mean to write the texi
> code which would require to have a build system running to see the rendered
> pages. Automagic screenshots would be even more advanced.
> > >>
> > >> Did you ever propose users just to make some kind of
> handcrafted tutorial or documentation, provide it in pdf under some CC
> license and we would publish it on the gnu website?
> > >>
> > >> Cheers
> > >>
> > >> Fritz
> > >>
> > >>
> >
>
>
>
> ------------------------------
>
> Message: 6
> Date: Wed, 23 Mar 2022 06:25:52 +0100
> From: Friedrich Beckmann <friedrich.beckmann@gmx.de>
> To: Ben Pfaff <blp@cs.stanford.edu>
> Cc: Alan Mead <amead2@alanmead.org>, PSPP Development Mailing List
> <pspp-dev@gnu.org>
> Subject: Re: Your automagic screenshots!
> Message-ID: <BC4FA759-8BCB-4EE2-B825-C5F4BA595070@gmx.de">BC4FA759-8BCB-4EE2-B825-C5F4BA595070@gmx.de>
> Content-Type: text/plain; charset=us-ascii
>
>
> I answered her in the mailing list to export from excel to csv and to
> import from csv to pspp. That seemed to be sufficient. I was more wondering
> how to engage people who probably are not in the position to install the
> build environment to render the documentation.
>
> Friedrich
>
> > Am 23.03.2022 um 04:59 schrieb Ben Pfaff <blp@cs.stanford.edu>:
> >
> > Maybe we should add instructions for conversion to the FAQ or the
> > manual. The batch mode instructions look helpful to me.
> >
>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Wed, 23 Mar 2022 10:29:39 +0100
> From: John Darrington <john@darrington.wattle.id.au>
> To: Friedrich Beckmann <friedrich.beckmann@gmx.de>
> Cc: Ben Pfaff <blp@cs.stanford.edu>, PSPP Development Mailing List
> <pspp-dev@gnu.org>
> Subject: Re: Your automagic screenshots!
> Message-ID: <YjrogwohhDQ3vxla@jocasta.intra>
> Content-Type: text/plain; charset=us-ascii
>
> The documentation including screenshots are included in the manual.
> If I recall correctly this includes the Windoze builds last time I
> checked.
>
> Regards,
>
> John
>
> On Wed, Mar 23, 2022 at 06:25:52AM +0100, Friedrich Beckmann wrote:
>
> I answered her in the mailing list to export from excel to csv and to
> import from csv to pspp. That seemed to be sufficient. I was more wondering
> how to engage people who probably are not in the position to install the
> build environment to render the documentation.
>
> Friedrich
>
> > Am 23.03.2022 um 04:59 schrieb Ben Pfaff <blp@cs.stanford.edu>:
> >
> > Maybe we should add instructions for conversion to the FAQ or the
> > manual. The batch mode instructions look helpful to me.
> >
>
>
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> pspp-dev mailing list
> pspp-dev@gnu.org
> https://lists.gnu.org/mailman/listinfo/pspp-dev
>
>
> ------------------------------
>
> End of pspp-dev Digest, Vol 209, Issue 4
> ****************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.gnu.org/archive/html/pspp-dev/ >attachments/20220324/4407f74b/ attachment.htm
------------------------------
Subject: Digest Footer
_______________________________________________
pspp-dev mailing list
pspp-dev@gnu.org
https://lists.gnu.org/mailman/listinfo/pspp-dev
------------------------------
End of pspp-dev Digest, Vol 209, Issue 5
****************************************
| [Prev in Thread] | Current Thread | [Next in Thread] |