質問する

petef.'s profile - activity

2015-09-08 08:27:57 +0200 バッジを受け取った  体系学者
2014-01-27 07:37:53 +0200 バッジを受け取った  有名な質問 (source)
2014-01-27 07:37:53 +0200 バッジを受け取った  卓越した質問 (source)
2014-01-27 07:37:53 +0200 バッジを受け取った  人気の質問 (source)
2014-01-21 00:08:43 +0200 バッジを受け取った  卓越した質問 (source)
2014-01-21 00:08:43 +0200 バッジを受け取った  有名な質問 (source)
2014-01-21 00:08:43 +0200 バッジを受け取った  人気の質問 (source)
2013-03-11 10:12:19 +0200 バッジを受け取った  サポーター (source)
2013-02-28 13:09:03 +0200 質問をする Unable to access ONLINE HELP

I am new to LibreOffice. I cannot access LibreOffice Online Help without getting a Security Certificate Error from IE (screen shot below). Is this a general issue, or am I the only one?

I still don't have an answer to this problem, and am unhappy about ignoring the warning.

I have tried inserting "www" as suggested, but page doesn't exist.

image description

2013-02-25 09:52:06 +0200 コメント付き回答 treatment of mathematical operations on text

Thanks. This will work as a workaround. I think in the long run I'll need to redesign my spreadsheets!

2013-02-24 20:53:52 +0200 バッジを受け取った  教師 (source)
2013-02-24 20:26:34 +0200 質問に回答する Is there a work-around for the formula/value display problem?

Does this problem occur only when the cell in question is formatted as a text cell??

If so this workaround has worked for me in the past:

  1. Before editing the formula, change the cell format from text to Number - General.
  2. Edit the formula in the cell, after editing it should display the value not the formula.
  3. You can now reformat the cell as text, and it should continue to display the value.

Hope this works for you.

2013-02-24 20:08:22 +0200 バッジを受け取った  学者 (source)
2013-02-24 12:35:47 +0200 質問をする Online Help Security Certificate

When I try to access LO online HELP (https://help.libreoffice.org/) I get IE message:

"There is a problem with this website's security certificate. The security certificate presented by this website was issued for a different website's address. Security certificate problems may indicate an attempt to fool you or intercept any data you send to the server.
We recommend that you close this webpage and do not continue to this website."

2013-02-24 11:59:04 +0200 質問をする treatment of mathematical operations on text

3.6.5.2 build 5b93205

I have just installed LibreOffice and am trying to migrate my Staroffice .xls spreadsheets. The .xls spreadsheets are openable with LibreOffice, but there is a problem with the treatment of non-numerical data when mathematical operations are performed. LibreOffice returns the error #VALUE! when it finds non-numerical data in a cell that is being operated on mathematically (this is correct according to the HELP Manual). StarOffice treats this situation differently, it just ignores the non-numerical data, so the mathematical operation can complete sucessfully.

EXAMPLE: In the formula =SUM(OFFSET(H683,-1,0),C683,-D683,E683) If one cell referenced by the formula has something other than a numerical value in it, then

  • LibreOffice returns #VALUE!
  • StarOffice ignores the non-numerical cell, and returns the
    outcome of the calculation. This is
    very useful in large complex
    spreadsheets. Is there a way round
    this in LibreOffice? I have tried to find one without success.

Thanks.