[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread Andreas Säger
Am 16.07.2015 um 23:08 schrieb Tom Davies: > Hi :) > If it's spread out into 2 columns (or rows) such that the day-of-the-week > (eg Mon) is in the first cell and then the date part is in the next cell > then both drag down fine. (I had to set the format of the cell before it > let me show the dat

Re: [libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread Tom Davies
Hi :) If it's spread out into 2 columns (or rows) such that the day-of-the-week (eg Mon) is in the first cell and then the date part is in the next cell then both drag down fine. (I had to set the format of the cell before it let me show the date in "MMM d" format but that's a side-issue imo). So

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread Piet van Oostrum
Andreas Säger wrote: > Problem is that too many spreadsheet users do not know what a > spreadsheet date/time is and how it differs from a text such as > "16/07/2015" which is not a date by any means. Actually it is if you add the pattern to Options > Language Settings > Languages > Date Accep

Re: [libreoffice-users] Europass docs

2015-07-16 Thread Malgosia Askanas
Many thanks. I did indeed ask for submissions, and will in the future try to ask for a non-".doc" format. Malgosia On 2015-07-15 12:35 PM, Dave Barton wrote The ".doc" files generated by Europass CV are a mess when opened in LO, no matter which version is used, including 5 RC3. They render a

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread Andreas Säger
Am 16.07.2015 um 18:49 schrieb tonybsa: > > The secret i using the Edit > Fill > Series menu options > > So now you have the dates, with days in the A column you could put time along > the the row 1. > Starting at B1 and use the Edit > Fill > Series >Right > Date . Start 08:00, > End 12:00 Inc

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread tonybsa
Use Edit > Fill > Series Click in cell A2 Right click Format Cells > date > Fri, 31Dec 99 > OK With A2 still selected shift click A6 Click Edit>Fill>Series When the dialog box opens Select Down > Date > Day Enter start date: 3/08/2015 Enter finish date: 7/08/2015 Increment: 1 Click OK Result: M

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread Andreas Säger
P.S. Am 16.07.2015 um 16:05 schrieb Andreas Säger: > In any case you should _never_ enter any weekday names. > > > Entering dates into LibreOffice is particularly difficult since version > 3.6. To make above mentioned input patterns working in LibreOffice, you > need to adjust the "date recogni

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread Andreas Säger
Am 15.07.2015 um 22:06 schrieb Gilles: > Hello > > I often use Calc to prepare multi-day trips, and have to write series that > look like this: > > Mon 1 Aug > Tue 2 Aug > Wed 3 Aug > etc. > > Does Calc come with a way to automate this tedious task, or is there some > macro that I could copy/pas

Re: [libreoffice-users] Installation Fail

2015-07-16 Thread Milos Sramek
Dear Timothy, This seems to be a problem on the Windows side, not LO. Please, try to google for Internal error 2503 8.1 You will get plenty of references - I hope they will help you best Milos On 2015-07-16 08:59, Timothy Galli wrote: > Hi all, > I have tried several times to download the Lib

[libreoffice-users] Re: Libre Office Base

2015-07-16 Thread Andreas Säger
Am 16.07.2015 um 10:51 schrieb Andreas Säger: > Am 16.07.2015 um 09:15 schrieb Ian Whitfield: >> Hi Andreas >> >> On 15/07/2015 17:32, Andreas Säger wrote: >>> SELECT * FROM "Table" ORDER BY "what","you","want" >> Thanks - I was hoping there was a way to do this from the GUI!! >>> > > The GUI is a

[libreoffice-users] Re: Libre Office Base

2015-07-16 Thread Andreas Säger
Am 16.07.2015 um 09:15 schrieb Ian Whitfield: > Hi Andreas > > On 15/07/2015 17:32, Andreas Säger wrote: >> SELECT * FROM "Table" ORDER BY "what","you","want" > Thanks - I was hoping there was a way to do this from the GUI!! >> The GUI is almost useless compared to the options that are provided b

Re: [libreoffice-users] Re: Libre Office Base

2015-07-16 Thread Gabriele Ponzo
2015-07-16 9:15 GMT+02:00 Ian Whitfield : > Hi Andreas > > On 15/07/2015 17:32, Andreas Säger wrote: > >> SELECT * FROM "Table" ORDER BY "what","you","want" >> > Thanks - I was hoping there was a way to do this from the GUI!! It is, more or less, in the GUI: You just have to open the Form's prop

Re: [libreoffice-users] Re: Libre Office Base

2015-07-16 Thread Ian Whitfield
Hi Andreas On 15/07/2015 17:32, Andreas Säger wrote: SELECT * FROM "Table" ORDER BY "what","you","want" Thanks - I was hoping there was a way to do this from the GUI!! The database engine (MySQL) has zero influence on the tick boxes. OK understood - but is there any way to adjust their size?

[libreoffice-users] Installation Fail

2015-07-16 Thread Timothy Galli
Hi all, I have tried several times to download the LibreOffice 4.4.4. and each time it fails. Error messages: Internal error 2503 and Internal error 2502. I have made a donation to the foundation in good faith, and cannot see why I can't download. I am running Windows8.1. I hope you can help Ti