#DIV/0!

[Robert Marshall]

Hi Marcus,

I was offering a solution.

The problem being when summing a series if any member is #DIV/0!

The result is #DIV/0!.

A simple solution is to sum the series in an available adjacent column.

If the amount shown in the original summation column is a number

enter the number in the new column. If #DIV/0! Enter 0!

sum as usual.

To enhance ease and accuracy maintain relative positioning.

In my Email I included the word amount in italics in your reply it became

amount/./

Hope this helps.

Re: Reproducible builds ...

[Pedro Giffuni]

Hi;

On 12/21/16 11:54, Pedro Giffuni wrote:

Hello;

It would be important to work on Reproducible builds:

https://reproducible-builds.org/

The first issue to be resolved is that the executable should NOT carry
the date it was built. We could carry the SVN revision value instead.

Perhaps someone may be interested in hunting down here the date is
introduced in the "About" box?



I hunted it down with some patience and it ended up being not difficult
after all. After r1775936 we should not be embedding dates anymore.

I can't really claim we are within reproducible builds though, someone
has to build it a couple of times and run a binary diff over the
packages.

Merry Christmas!

Pedro.


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: OpenOffice on KDE 4 issues

[Raphael Bircher]

Hi Damian, *


Am 12/24/2016 um 1:07 AM schrieb Damjan Jovanovic:

On Thu, Dec 22, 2016 at 8:06 PM, Kay Schenk  wrote:


On 2016-12-20 20:28 (-0800), Damjan Jovanovic  wrote:

Hi

I am busy porting fpicker to gbuild, and needed to test its KDE 4 version,
and ended up fixing a bug there, and a VCL bug on KDE that stopped AOO from
starting.

However we still have this duplicate text issue in the menu, and dialog
corruption:




Any KDE users? Any thoughts?

Thank you
Damjan


Mostly, the KDE specific build option is no longer needed. Both KDE and Gnome use 
Freedesktop interfaces now. That interface via VCL may need some tweaking, I don't know. 
When I tried to build with "--enable-KDE" at least 2 years ago, it was a bit of 
a chore due to the overhead of installing the needed KDE development stuff. Better to 
just concentrate on Freedesktop and ditch the KDE specific code altogether I think.


Checking for usage of ENABLE_KDE and ENABLE_KDE4 on OpenGrok:
* main/cui/source/options/optgdlg.cxx and
main/filepickers/source/unx/kde4 deal with file pickers.
* main/shell/source/backends/kdebe reads KDE's network proxy settings,
the external mailer, source view font properties, etc.
* main/vcl/unx/kde4 deals with libQt's main loop integration, event
filtering, decides which controls to draw natively, matches fonts with
system fonts, input methods, etc.
* main/toolkit/source/layout/core/dialogbuttonhbox.cxx selects
ordering for dialog buttons

These are generally tasks that go beyond what Freedesktop provides.
Thanks for the good analystic work. Maybe this is exactly a problem for 
the dublicate menus. Maybe OpenOffice renders the manu twice. first with 
normal Linux and seccond with kde4. And finaly you have the text twice. 
I have to say, I'm not familiar with this source. It's just a srange 
idea from an "outside view."


Regards, Raphael


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: OpenOffice on KDE 4 issues

[Damjan Jovanovic]

On Thu, Dec 22, 2016 at 8:06 PM, Kay Schenk  wrote:
>
>
> On 2016-12-20 20:28 (-0800), Damjan Jovanovic  wrote:
>> Hi
>>
>> I am busy porting fpicker to gbuild, and needed to test its KDE 4 version,
>> and ended up fixing a bug there, and a VCL bug on KDE that stopped AOO from
>> starting.
>>
>> However we still have this duplicate text issue in the menu, and dialog
>> corruption:
>>
>>
>>
>>
>> Any KDE users? Any thoughts?
>>
>> Thank you
>> Damjan
>>
>
> Mostly, the KDE specific build option is no longer needed. Both KDE and Gnome 
> use Freedesktop interfaces now. That interface via VCL may need some 
> tweaking, I don't know. When I tried to build with "--enable-KDE" at least 2 
> years ago, it was a bit of a chore due to the overhead of installing the 
> needed KDE development stuff. Better to just concentrate on Freedesktop and 
> ditch the KDE specific code altogether I think.
>

Checking for usage of ENABLE_KDE and ENABLE_KDE4 on OpenGrok:
* main/cui/source/options/optgdlg.cxx and
main/filepickers/source/unx/kde4 deal with file pickers.
* main/shell/source/backends/kdebe reads KDE's network proxy settings,
the external mailer, source view font properties, etc.
* main/vcl/unx/kde4 deals with libQt's main loop integration, event
filtering, decides which controls to draw natively, matches fonts with
system fonts, input methods, etc.
* main/toolkit/source/layout/core/dialogbuttonhbox.cxx selects
ordering for dialog buttons

These are generally tasks that go beyond what Freedesktop provides.

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: #DIV/0!

[Marcus]

Am 12/23/2016 09:28 PM, schrieb Robert Marshall:

As a Calc user with next to no programming experience, my solution for
#DIV/0! is simple.

In summing a series, in an available column , for amounts - enter the
/amount/.

For #DIV/0! - enter 0. To enhance ease and accuracy maintain relative
positioning.

Love Calc.


I'm sorry but I don't understand your problem. What do you mean with 
"solution for #DIV/0!"? Do you have problems with some formulas?


It would be great if you can explain it with different words.

Thanks

Marcus


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

#DIV/0!

[Robert Marshall]

As a Calc user with next to no programming experience, my solution for 
#DIV/0! is simple.



In summing a series, in an available column , for amounts - enter the 
/amount/.


For #DIV/0! - enter 0. To enhance ease and accuracy maintain relative 
positioning.



Love Calc.

Re: Pootle server admins (was Re: create a Pootle account for me)

[Ariel Constenla-Haile]

On 20/12/16 16:56, Andrea Pescetti wrote:
> You are a "superuser" in Pootle now. Please check if you see an
> "ADMIN" link top right next to your username (logout/login might be
> needed).

Yes, I can see the ADMIN. Thanks.


Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina



signature.asc
Description: OpenPGP digital signature

Re: Remove survey.openoffice.org (was [Homepage] SSL error on survey.openoffice.org)

[Matthias Seidel]

Hi Raphael,

Great, thanks!

regards, Matthias


Am 23.12.2016 um 16:21 schrieb Raphael Bircher:
> Hi Matthias, *
>
> It's now https://issues.apache.org/jira/browse/INFRA-13167 .
>
> Regards Raphael
>
>
> Am 12/23/2016 um 3:56 PM schrieb Matthias Seidel:
>> Hi Raphael,
>>
>> Did you file an issue for that?
>> We could keep the subdomain. But the survey must be deactivated...
>>
>> regards, Matthias
>>
>> P.S.: I wish everyone on the list happy holidays!
>>
>>
>> Am 18.12.2016 um 13:14 schrieb Raphael Bircher:
>>> Hi Matthias
>>>
>>> Let's wait util Tuesday, so everyone has the Chance to react, if we
>>> rich lazy consensus, i will fill the issue for the infra.
>>>
>>> Regards, Raphael
>>>
>>>
>>> Am 12/18/2016 um 12:52 PM schrieb Matthias Seidel:
 Hi Raphael,

 I removed the link to that page in the footer of our homepage.

 However, the sub-domain should definitely be deactivated/removed.

 So +1 from me.

 regards, Matthias


 Am 17.12.2016 um 00:37 schrieb Raphael Bircher:
> Hi all,
>
> Am 12/16/2016 um 11:54 PM schrieb Matthias Seidel:
>
>> Hi Marcus,
>>
>> Yes, that should be easy...
>>
>> But who takes care of the misconfigured sub-domain?
>> If it is not used, it should be deleted. It still is available over
>> http...
> I asked Infra. If we want to delete the subdomain, we have to fill an
> issue for ASFInfra. But I think, first we should get lazy consensus.
>
> Regards, Raphael
>> regards, Matthias
>>
>>
>> Am 16.12.2016 um 23:02 schrieb Marcus:
>>> Am 12/13/2016 10:49 PM, schrieb Matthias Seidel:
 On our Homepage there is a link "Website Feedback" in the footer.
 It links to https://survey.openoffice.org/index.php/833861/lang-en

 With Firefox I get: SSL_ERROR_RX_RECORD_TOO_LONG
 with Chrome: ERR_SSL_PROTOCOL_ERROR

 With http the page can be accessed, so it is an SSL error on that
 sub-domain.

 Is this something we can fix or should Infra be contacted?
>>> I would delete the link as it is no longer used. So, the fix
>>> could be
>>> easy. ;-)
>>>
>>> Marcus
>>>
>>> -
>>>
>>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>>
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>
>
>>>
>>> -
>>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>>
>>>
>>
>
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>




smime.p7s
Description: S/MIME Cryptographic Signature

Re: Remove survey.openoffice.org (was [Homepage] SSL error on survey.openoffice.org)

[Raphael Bircher]

Hi Matthias, *

It's now https://issues.apache.org/jira/browse/INFRA-13167 .

Regards Raphael


Am 12/23/2016 um 3:56 PM schrieb Matthias Seidel:

Hi Raphael,

Did you file an issue for that?
We could keep the subdomain. But the survey must be deactivated...

regards, Matthias

P.S.: I wish everyone on the list happy holidays!


Am 18.12.2016 um 13:14 schrieb Raphael Bircher:

Hi Matthias

Let's wait util Tuesday, so everyone has the Chance to react, if we
rich lazy consensus, i will fill the issue for the infra.

Regards, Raphael


Am 12/18/2016 um 12:52 PM schrieb Matthias Seidel:

Hi Raphael,

I removed the link to that page in the footer of our homepage.

However, the sub-domain should definitely be deactivated/removed.

So +1 from me.

regards, Matthias


Am 17.12.2016 um 00:37 schrieb Raphael Bircher:

Hi all,

Am 12/16/2016 um 11:54 PM schrieb Matthias Seidel:


Hi Marcus,

Yes, that should be easy...

But who takes care of the misconfigured sub-domain?
If it is not used, it should be deleted. It still is available over
http...

I asked Infra. If we want to delete the subdomain, we have to fill an
issue for ASFInfra. But I think, first we should get lazy consensus.

Regards, Raphael

regards, Matthias


Am 16.12.2016 um 23:02 schrieb Marcus:

Am 12/13/2016 10:49 PM, schrieb Matthias Seidel:

On our Homepage there is a link "Website Feedback" in the footer.
It links to https://survey.openoffice.org/index.php/833861/lang-en

With Firefox I get: SSL_ERROR_RX_RECORD_TOO_LONG
with Chrome: ERR_SSL_PROTOCOL_ERROR

With http the page can be accessed, so it is an SSL error on that
sub-domain.

Is this something we can fix or should Infra be contacted?

I would delete the link as it is no longer used. So, the fix could be
easy. ;-)

Marcus

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org




-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org







-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Remove survey.openoffice.org (was [Homepage] SSL error on survey.openoffice.org)

[Matthias Seidel]

Hi Raphael,

Did you file an issue for that?
We could keep the subdomain. But the survey must be deactivated...

regards, Matthias

P.S.: I wish everyone on the list happy holidays!


Am 18.12.2016 um 13:14 schrieb Raphael Bircher:
> Hi Matthias
>
> Let's wait util Tuesday, so everyone has the Chance to react, if we
> rich lazy consensus, i will fill the issue for the infra.
>
> Regards, Raphael
>
>
> Am 12/18/2016 um 12:52 PM schrieb Matthias Seidel:
>> Hi Raphael,
>>
>> I removed the link to that page in the footer of our homepage.
>>
>> However, the sub-domain should definitely be deactivated/removed.
>>
>> So +1 from me.
>>
>> regards, Matthias
>>
>>
>> Am 17.12.2016 um 00:37 schrieb Raphael Bircher:
>>> Hi all,
>>>
>>> Am 12/16/2016 um 11:54 PM schrieb Matthias Seidel:
>>>
 Hi Marcus,

 Yes, that should be easy...

 But who takes care of the misconfigured sub-domain?
 If it is not used, it should be deleted. It still is available over
 http...
>>> I asked Infra. If we want to delete the subdomain, we have to fill an
>>> issue for ASFInfra. But I think, first we should get lazy consensus.
>>>
>>> Regards, Raphael
 regards, Matthias


 Am 16.12.2016 um 23:02 schrieb Marcus:
> Am 12/13/2016 10:49 PM, schrieb Matthias Seidel:
>> On our Homepage there is a link "Website Feedback" in the footer.
>> It links to https://survey.openoffice.org/index.php/833861/lang-en
>>
>> With Firefox I get: SSL_ERROR_RX_RECORD_TOO_LONG
>> with Chrome: ERR_SSL_PROTOCOL_ERROR
>>
>> With http the page can be accessed, so it is an SSL error on that
>> sub-domain.
>>
>> Is this something we can fix or should Infra be contacted?
> I would delete the link as it is no longer used. So, the fix could be
> easy. ;-)
>
> Marcus
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>
>>>
>>> -
>>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>>
>>>
>>
>
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>
>




smime.p7s
Description: S/MIME Cryptographic Signature