Re: 3 withstanding functions?

[Bastián Díaz]

The pasted version you see in the picture, is how it works in linux commonly.

Try importing one or more tables in html in excel, copy them and paste them on another sheet. All paste options listed (including paste special), are the options that should show commonly. You will see that and in that sense is pretty good.

Regards

 

--
Bastián Díaz

---

De: Fredrik Clementz <address@hidden>
Para: Bastián Díaz <address@hidden>
CC: "address@hidden" <address@hidden>
Enviado: Viernes, 6 de septiembre, 2013 10:33:17
Asunto: RE: 3 withstanding functions?

Bastian,

I see what you mean, the lower one definitely reach my expectations.

Only 2 followups.... When you try To fix the cause of the copy html issue, perhaps look Into multi select and right click copy as well?

And as a sidenote, your pasted version in looks far better than what a pspp output look like.

I appreciate the effort, good job

Sent from my Windows Phone

---

From: Bastián Díaz
Sent: ‎2013-‎09-‎06 15:31
To: Fredrik Clementz
Cc: address@hidden
Subject: Re: 3 withstanding functions?

Fredrik.

I tested and I get the same results under Windows, using Office 2007 and Office 2010.

It seems to copy tables in PSPP and then paste in Office, it only recognizes the formats of "plain text" or "unicode text" and therefore lost the format (may be wrong) because usually text copy to clipboard in HTML format.

Attached is a picture that shows how a table is common copying Office (unicode text) and how it should look (html). The table in HTML format it succeeds on importing PSPP output in HTML format into another Excel file.

Usually, I have no problem using Libreoffice as I automatically detects the format of the tables. However, I will do some tests to identify the problem and if necessary make a bug report.

Greetings.

--
Bastián Díaz

---

De: Fredrik Clementz <address@hidden>
Para: Bastián Díaz <address@hidden>
CC: "address@hidden" <address@hidden>
Enviado: Viernes, 6 de septiembre, 2013 3:23:08
Asunto: Re: 3 withstanding functions?

Hi Bastian,

Thank you for your swift reply.

Regarding the Variable Labels / names... thank you.. I didn't know it was available under right click =)

Will post a report on the merge files....

Now the "office" question.
My background is in the commercial world, and if we do an operation say 50 times a day, we can't manually edit the output in Excel for every export to make it look descent when the alternative software does this automatically. Please, view the attached movie. From a commercial standpoint, we'd loose say 2-3 minutes at any given time, and multiplying that by say 50, it is not an option.
http://screencast.com/t/tb0tpM19s

At any given time, any output that is produced from PSPP will most likely end in Excel or equivalent one way or the other. To make it difficult for users to get there is really not best practice and it will effectively hinder any commercial adoption at all. I believe this is the reason why R is so widely used in the academic world but not in the commercial world because there is output constraints....

I can't really tell how much work it would be to make the output look descent, I'm just saying that it's a dealbreaker for me and most likely many like me.

Kind regards,

F

On Thu, Sep 5, 2013 at 8:24 PM, Bastián Díaz <address@hidden> wrote:

Hello Fredrik,

I'm not a developer, but I have joined the project for a while to make a new artwork for PSPP.

I read your post, and I can say that can make PSPP if some of the things you mention.


→ Office: PSPP can interoperate with MS office or other office suite in many ways.
If we talk only of the output file, it can be exported to a number of files that are compatible with MS Office. For example if you want to work with Excel, just export your PSPP output to CSV and import it into Excel. If you want to keep the format, you can choose to export your PSPP output in HTML format and then import it into Excel (also applies to Word or PowerPoint).
If you're working in Word, you can use export to OpenDocument Text (*.odt) incorporated into PSPP (OpenDocument Format is supported on MS Office since version 2007).
However if you just want to copy one or more tables or graphs directly from PSPP output, just select the table or tables you need (from the sidebar) and then copy (from the keyboard shortcut Ctrl+C or from the edit menu) and then paste in Excel, Word or PowertPoint.


→ As mention in section 3, there are some features that still do not have GUI. For example, if in the output window showed up a context menu to select tables or graphs with secondary click the "copy" option, many would have realized that you can make that choice directly without exporting the entire file completely.

→ Finally if it is effective to change "variable names" to "variable labels" in the various system dialogs. Made me want to open a dialog box, and the secondary click option appears "prefer variable labels" which can be enabled or disabled.

If considered an important feature to be included in PSPP (eg GUI for merging files), please create a bug report with the corresponding request.

Regards

--
Bastián Díaz

--
Fredrik Clementz

Reflect AB
Fenixpalatset
Adolf Fredriks Kyrkogata 10, 4tr
111 37 Stockholm

Direkt: 08 - 412 26 94
Fax: 0708 - 27 79 37
Mobil: 0709 - 99 52 36

E-mail: address@hidden
Url: www.reflect.se

Om Reflect
Reflect är ett undersökningsföretag specialiserat på kvantitativa undersökningar. Med undersökningar som verktyg lär vi företag att förstå sina marknader, sin organisation och omvärld. Undersökningarna som genomförs tillsammans med Reflect avser fungera som en språngbräda inför framtiden. Vi levererar beslutsunderlag som snabbt skall kunna användas för att öka utväxlingen i företag och organisationer