Re: [libreoffice-users] LinuxQuestions.org Members Choice Awards - "Office Suite of the Year" - vote

2017-01-08 Thread John R. Sowden
I have been using LO since the beginning of its time, OO since its beginning of time, and Star Office before that. BUT, a close relative, who uses Windows and MSO, uses it because: (a) It's a bother to learn something new, (b) the files don't always show up right, (c) her other colleagues (sch

Re: [libreoffice-users] LinuxQuestions.org Members Choice Awards - "Office Suite of the Year" - vote

2017-01-08 Thread Tom Davies
Hi :) I think it might be more meaningful if they included MS Office and other proprietary options including Android and iPad options such as "Author". Many people claim that there are no alternatives to MS Office and that "even if there were" they would still have to use it. Many others claim to

[libreoffice-users] Format issue in latest calc [Libreoffice 5.2.4002]

2017-01-08 Thread Robert Peirce
I have a date column with the format MM/. I just added the next twelve months and it was formatted [M]M/, so I tried to reformat it. The option SAYS MM/ but it still comes out [M]M/. Is this a bug in the latest release or am I doing something wrong? -- To unsubscribe e-mail

[libreoffice-users] Re: Issues with date fields in dialogues

2017-01-08 Thread Andreas Säger
[Tutorial] Date-Time Conversion in StarBasic including a spreadsheet document and a Basic function which converts all types of dates, times, timestamps into any other type. Date-times can be represented by UNO structs, integers,

Re: [libreoffice-users]

2017-01-08 Thread Cley Faye
2017-01-08 10:38 GMT+01:00 Vaibhav Banait : > I use Calc to do invoicing. I use one sheet per invoice and one calc file > per day. I calculate total amount invoiced using formula =Sum > (sheet2.B25:sheet16:B25). I generate 25 files per month x 12 month. Is > there a way I can calculate total amoun

[libreoffice-users] LinuxQuestions.org Members Choice Awards - "Office Suite of the Year" - vote

2017-01-08 Thread Marc Paré
Hi all, The site LinuxQuestions.org is again offering users the chance to vote on their "Members Choice Awards" categories. They are debating this year as to whether do away with the "Office Suite of the Year" award, as LibreOffice usually wins by such a wide margin. Feel free to add your vo

[libreoffice-users]

2017-01-08 Thread Vaibhav Banait
I use Calc to do invoicing. I use one sheet per invoice and one calc file per day. I calculate total amount invoiced using formula =Sum (sheet2.B25:sheet16:B25). I generate 25 files per month x 12 month. Is there a way I can calculate total amount invoiced in a year by using some formula by pa

[libreoffice-users] Help with calc

2017-01-08 Thread Vaibhav Banait
I use Calc to do invoicing. I use one sheet per invoice and one calc file per day. I calculate total amount invoiced using formula =Sum (sheet2.B25:sheet16:B25). I generate 25 files per month x 12 month. Is there a way I can calculate total amount invoiced in a year by using some formula by par