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

[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 (school teacher) use MS O, so they discus doing things using 
MS O, and (d) most importantly, using 'something different' gets in the 
way of her doing her job (excellent school teacher).  I mention this 
because I feel that these are real facts of life when it comes to being 
a pioneer, using Linux and LO, or even LO under Windows.  I use Linux 
mainly because of the freedom based on technology, not structure based 
on profits.


John


On 01/08/2017 04:36 PM, Tom Davies wrote:

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
have tried all the alternatives but that nothing is as good as MS Office.
It is good to have a place that consistently rubbishes such idiots.

Those sort of people claim that because there is no alternative to MS
Office they couldn't possible move away from Windows.

So i really think this is a crucial category for LinuxQuestions.com.
Regards from
Tom :)




On 8 January 2017 at 09:43, Marc Paré  wrote:


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 voice and spread the word about the vote! You may
find the voting site here: http://www.linuxquestions.org/
questions/2016-linuxquestions-org-members-choice-awards-123/
office-suite-of-the-year-4175596296/

On the topic over whether they should close this particular category, IMO,
if there were no other office suite choices other than LibreOffice, then
closing the category would make sense. However, there are plenty of choices
in the Linux office suite arena and it is always nice to see how people in
general feel of their most favourite office suite. Yes, the margins are
quite wide between LibreOffice and the next second office suite choice,
however, it is always nice to see who is in second, third, fourth place
standing. It is also always nice to see that the work put into LibreOffice
is validated by an outpouring of its users.

I would then suggest that we should not only place our vote for
LibreOffice, but make sure to comment on the page, that the "Office Suite
of the Year Award" not be closed. The category not only validates the
TDF/LibreOffice achievement, but also serves to validate and recognize
other open source/for-profit projects in the office suite category,
regardless of the standing. I cannot imagine how the awards scene would
look like if all other award organizations decided to do the same and close
down categories for the same reason.

Hope you can take time to vote for your favourite office suite and feel
free to browse the other categories on the site.

Cheers,

Marc

--
Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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
have tried all the alternatives but that nothing is as good as MS Office.
It is good to have a place that consistently rubbishes such idiots.

Those sort of people claim that because there is no alternative to MS
Office they couldn't possible move away from Windows.

So i really think this is a crucial category for LinuxQuestions.com.
Regards from
Tom :)




On 8 January 2017 at 09:43, Marc Paré  wrote:

> 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 voice and spread the word about the vote! You may
> find the voting site here: http://www.linuxquestions.org/
> questions/2016-linuxquestions-org-members-choice-awards-123/
> office-suite-of-the-year-4175596296/
>
> On the topic over whether they should close this particular category, IMO,
> if there were no other office suite choices other than LibreOffice, then
> closing the category would make sense. However, there are plenty of choices
> in the Linux office suite arena and it is always nice to see how people in
> general feel of their most favourite office suite. Yes, the margins are
> quite wide between LibreOffice and the next second office suite choice,
> however, it is always nice to see who is in second, third, fourth place
> standing. It is also always nice to see that the work put into LibreOffice
> is validated by an outpouring of its users.
>
> I would then suggest that we should not only place our vote for
> LibreOffice, but make sure to comment on the page, that the "Office Suite
> of the Year Award" not be closed. The category not only validates the
> TDF/LibreOffice achievement, but also serves to validate and recognize
> other open source/for-profit projects in the office suite category,
> regardless of the standing. I cannot imagine how the awards scene would
> look like if all other award organizations decided to do the same and close
> down categories for the same reason.
>
> Hope you can take time to vote for your favourite office suite and feel
> free to browse the other categories on the site.
>
> Cheers,
>
> Marc
>
> --
> Marc Paré
> m...@marcpare.com
> http://www.parEntreprise.com
> parEntreprise.com Supports OpenDocument Formats (ODF)
> parEntreprise.com Supports http://www.LibreOffice.org
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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, doubles, Basic type Date,  ISO-strings
and localized strings.



--
View this message in context: 
http://nabble.documentfoundation.org/Issues-with-date-fields-in-dialogues-tp4204266p4204607.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users]

[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 amount invoiced in a year by using some
> formula by parsing the files considering the total of the day is on
> sheet1.B25Kindly help


A
​ssu​ming you have some sort of naming convention for your files, it is
easy to do. You can reference other files from within a sheet.

Here are two way to do it with two "day" file and a "summary" file.
Assuming the total in the day files is on sheet1.A1.

First solution is to use these formula:

='file:///E:/day1.ods'#$Sheet1.A1
='file:///E:/day2.ods'#$Sheet1.A1

They will pull data from the file given in reference.
But as you see, you have to put the file path in full (relative URL won't
work). There's a way to easily make this scalable to many days if you use
INDIRECT(). In your "summary" file, put the file path somewhere (in my
example it'll be E1) and the day file names in a col (for example C:C),
then use these formula to get your results:

=INDIRECT("'file:///"&E$1&C1&".ods'#$Sheet1.A1")
=INDIRECT("'file:///"&E$1&C2&".ods'#$Sheet1.A1")

that way you can quickly get the results from many days, and if you have to
move your files around you only have to update a single cell instead of all
of them.

This should give you a good example on how to achieve this:
http://www.cjoint.com/c/GAikfTZMQFc

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 voice and spread the word about the vote! You may 
find the voting site here: 
http://www.linuxquestions.org/questions/2016-linuxquestions-org-members-choice-awards-123/office-suite-of-the-year-4175596296/


On the topic over whether they should close this particular category, 
IMO, if there were no other office suite choices other than LibreOffice, 
then closing the category would make sense. However, there are plenty of 
choices in the Linux office suite arena and it is always nice to see how 
people in general feel of their most favourite office suite. Yes, the 
margins are quite wide between LibreOffice and the next second office 
suite choice, however, it is always nice to see who is in second, third, 
fourth place standing. It is also always nice to see that the work put 
into LibreOffice is validated by an outpouring of its users.


I would then suggest that we should not only place our vote for 
LibreOffice, but make sure to comment on the page, that the "Office 
Suite of the Year Award" not be closed. The category not only validates 
the TDF/LibreOffice achievement, but also serves to validate and 
recognize other open source/for-profit projects in the office suite 
category, regardless of the standing. I cannot imagine how the awards 
scene would look like if all other award organizations decided to do the 
same and close down categories for the same reason.


Hope you can take time to vote for your favourite office suite and feel 
free to browse the other categories on the site.


Cheers,

Marc

--
Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users]

[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 
parsing the files considering the total of the day is on sheet1.B25Kindly help 
Vaibhav 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Help with calc

[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 
parsing the files considering the total of the day is on sheet1.B25Kindly help 

Vaibhav BANAIT

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted