Re: Save big file

2013-10-20 Thread Andrea Pescetti
TN Patriot wrote: So yes, there does seem to be a bug with opening and saving large files. No. Large files, in general, open and save with similar performance in 3.x and 4.0.1, or are opened by 4.0.1 faster than 3.x. But there are a few problematic files, like the one discussed in issue 123

Re: Save big file

2013-10-20 Thread Joost Andrae
Hi, and once it is loaded you save it using "Save As...". Loading this file containing the "repaired" structure loads in an acceptable amount of time. btw. the file referenced in https://issues.apache.org/ooo/show_bug.cgi?id=123457 is really a beast... Kind regards, Joost Am 20.10.2013 10

Re: Save big file

2013-10-20 Thread John Meyer
On 10/19/2013 7:46 AM, Henry Bohné wrote: I recently upgraded from ver3.3 to ver 4.0. I work with a big (2.2 MB) text file. With ver3.3 it took 5 to 9 minutes to save the file, with ver4.0 it takes 29 minutes. How can I speed it up? I'm using Windows 7 as OS Henry Bohné

Re: Save big file

2013-10-20 Thread Alexandro Colorado
I would rather think this file has large images that could be re-rendered or externally linked. If its a huge spreadsheet probably transfer to a database. -- Sent from my Nokia N900 On Sun Oct 20 08:41:02 2013 John Meyer wrote: > On 10/19/2013 7:46 AM, Henry Bohné wrote: > > I recently upgrade

Re: Save big file

2013-10-20 Thread John Meyer
On 10/20/2013 7:50 AM, Alexandro Colorado wrote: I would rather think this file has large images that could be re-rendered or externally linked. If its a huge spreadsheet probably transfer to a database. In a text file? - T

SQL problem

2013-10-20 Thread John Meyer
Relevant tables and fields: Agents TSR Varchar(6) Sales SalesRep Varchar(6) neither is a primary key (I'm having problems converting it to a primary key when I import the data from a spread sheet). I want to find out how many sales each agent got. Statement: SELECT "Agents"."TSR", "Age

Re: SQL problem

2013-10-20 Thread John Meyer
Semi-solved, I think. I managed to join the following: SELECT "AGENTS"."AGENT_ID", COUNT(*) AS "Total Sales" FROM "AGENTS" INNER JOIN "SALES" ON "AGENTS"."AGENT_ID"="SALES"."SALES_REP" GROUP BY "AGENTS"."AGENT_ID" The only problem is I can't seem to add the agent's name. -

Re: SQL problem (SOLVED)

2013-10-20 Thread John Meyer
On 10/20/2013 1:14 PM, John Meyer wrote: Semi-solved, I think. I managed to join the following: SELECT "AGENTS"."AGENT_ID", COUNT(*) AS "Total Sales" FROM "AGENTS" INNER JOIN "SALES" ON "AGENTS"."AGENT_ID"="SALES"."SALES_REP" GROUP BY "AGENTS"."AGENT_ID" The only problem is I can't seem to

how to rotate a table

2013-10-20 Thread Uwe Brauer
Hi I googled a bit but found no solution to the problem of rotating a table such that | 1 | 2 | 3 | | 4 | 3 | 4 | becomes | 4 | 1 | | 3 | 2 | | 4 | 3 | Thanks Uwe Brauer - To unsubscribe, e-mail: users-unsubscr...@open

Re: how to rotate a table

2013-10-20 Thread Brian Barker
At 21:54 20/10/2013 +0200, Uwe Brauer wrote: I googled a bit but found no solution to the problem of rotating a table such that | 1 | 2 | 3 | | 4 | 3 | 4 | becomes | 4 | 1 | | 3 | 2 | | 4 | 3 | Do you mean a table in a text (Writer) document? o Copy the table. o Paste into a spreadsheet (Cal

on rotating tables

2013-10-20 Thread johnny smith
On Sun, 20 Oct 2013 19:54:16 -, Uwe Brauer wrote: I googled a bit but found no solution to the problem of rotating a table such that | 1 | 2 | 3 | | 4 | 3 | 4 | becomes | 4 | 1 | | 3 | 2 | | 4 | 3 | first, invert the range vertically, e.g. by adding the column with consecutive numbers t

Re: how to rotate a table

2013-10-20 Thread John Meyer
On 10/20/2013 1:54 PM, Uwe Brauer wrote: Hi I googled a bit but found no solution to the problem of rotating a table such that | 1 | 2 | 3 | | 4 | 3 | 4 | becomes | 4 | 1 | | 3 | 2 | | 4 | 3 | Thanks Uwe Brauer http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_TRANSPOSE_funct

Re: rotating tables in calc

2013-10-20 Thread johnny smith
On Sun, 20 Oct 2013 19:54:16 -, Uwe Brauer wrote: I googled a bit but found no solution to the problem of rotating a table such that | 1 | 2 | 3 | | 4 | 3 | 4 | becomes | 4 | 1 | | 3 | 2 | | 4 | 3 | first, invert the range vertically, e.g. by adding the column with consecutive numbers t

Presentation

2013-10-20 Thread Andreo.Marszalkowski
I like to be in contact with those knowing Polish and Esperanto and the ethnic Kashubian language. I am a professional translator for several languages and like to work at the translation of Open Office into the international language Esperanto. I'm also the owner of Familia Publishers

Re: Presentation

2013-10-20 Thread Alexandro Colorado
Hi Andreo, please subscribe to our l10n mailing list and forward your message, we have a lot of instructions regarding establishing new language projects, and others. you will need to request your credentials to our systems like pootle and others. Also please read our translation introductory modul