Bug 92401 - Help in Calc for "conversion"
Summary: Help in Calc for "conversion"
Status: RESOLVED MOVED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
4.4.3.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-28 10:28 UTC by gmarco
Modified: 2017-01-07 20:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot help for "time format conversion" (332.62 KB, image/jpeg)
2015-06-28 10:28 UTC, gmarco
Details
screenshot help for "text to numbers conversion" (330.16 KB, image/jpeg)
2015-06-28 10:31 UTC, gmarco
Details
IT and EN help screenshot (225.20 KB, image/jpeg)
2017-01-07 15:47 UTC, gmarco
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gmarco 2015-06-28 10:28:33 UTC
Created attachment 116886 [details]
screenshot help for "time format conversion"

Opening the local help in Calc and finding for "Conversione" (conversion) then clicking on "Conversione formato orario" (time format) displays the help "Convertire testo in numeri" (converting text to numbers), the same help dispayed clicking on "testo in numeri" (see the attachments).

You can look at that text help at the link https://help.libreoffice.org/Calc/Converting_Text_to_Numbers

<<< Converting Text to Numbers  (= IT version: Convertire testo in numeri)
Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error.
.......... >>>

The question:
I don't think that is the issue, they are two different arguments.
Further, the help is not clear and example too is very poor (is that what you intend for "conversion"?.

May you investigate and explain?
Thanks
Comment 1 gmarco 2015-06-28 10:31:06 UTC
Created attachment 116887 [details]
screenshot help for "text to numbers conversion"
Comment 2 Valter Mura 2015-07-02 18:30:45 UTC
These are simply different links to the same page. Maybe we can render in a different way the translation, so that you can find them in a different and far place.

I could change, for example,  "Conversione formato orario" to "Orario, conversione del formato".
Comment 3 Adolfo Jayme Barrientos 2015-11-26 20:02:30 UTC
@gmarco: As Valter explained in comment 2, those entries in “Index” (Indice) both link to the same page, which is normal in an index. Indices help you find topics with various keywords. Don’t confuse it with the actual topic tree, which is the purpose of the “Contents” (Contenuto) tab.

What is your opinion on Valter’s suggested change in translation?
Comment 4 gmarco 2015-11-28 22:15:34 UTC
(In reply to Adolfo Jayme from comment #3)
Hi Adolfo, thanks for reminding me the question.
The argument is a bit more complex and in July I had reasoned privately with Valter (Italian like me) because my mastery of English is limited.
I have some experience and exactly know the mean and the difference between an index, a cross reference, and so on. I well know also the big difficulties in constructing good help/guides and related references/keywords.
I am now using LO 5.0.3.2 and something has been revised, but much work would be still to do, I think Valter is aware of the matter.
A few examples only:
1- searching for “convertire” I can get some items, between them I see the function ORARIO but nothing about other functions like FISSO, T, CONVERTI, NUM, ORARIO.VALORE, … 
2- digiting instead into the search field “convers” it gets automatically fullfilled “conversione formato orario” and I get two items only (ORARIO.VALORE and Convertire testo in numeri).
3- probably it is not a documentation matter, it might be a bug, but the function ORARIO.VALORE gives “Err:502”: try to input =ORARIO.VALORE("4PM") or =ORARIO.VALORE("24:00") as in the examples.
4- digiting for searching FISSO or T (only as examples) I cannot see the related items, I can find infos only opening the item “Categoria Testo”.
This said, I think the question has a minor importance and can be closed.
Comment 5 gmarco 2016-03-09 18:23:14 UTC
The item is still in NEEDINFO status, but I was thinking to have replied on november last.
What about?
Comment 6 Xisco Faulí 2016-10-10 11:24:21 UTC Comment hidden (obsolete)
Comment 7 gmarco 2016-10-10 12:48:24 UTC
Hi,
I was thinking to have already replied on 2015-11-28.
Nevertheless I can now say:
- the local help has changed a lot and I cannot repeat the previous observations
- but a question is still present
3- probably it is not a documentation matter, it might be a bug, but the function ORARIO.VALORE gives “Err:502”: try to input =ORARIO.VALORE("4PM") or =ORARIO.VALORE("24:00") as in the examples.
 
Will you verify?
Let me know
Regards
Comment 8 gmarco 2017-01-07 15:45:22 UTC
(In reply to Xisco Faulí from comment #6)
> Dear Bug Submitter,
> 
> This bug has been in NEEDINFO status with no change for at least
> 6 months. Please provide the requested information as soon as
> possible and mark the bug as UNCONFIRMED. Due to regular bug
> tracker maintenance, if the bug is still in NEEDINFO status with
> no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
> due to lack of needed information.
> 
Really the bug is still today in NEEDINFO status xxx I had already replied.
Anyway I don't understand which info are needed: the function ORARIO.VALORE as exemplified in both online and local help gives “Err:502”: try to input =ORARIO.VALORE("4PM") or =ORARIO.VALORE("24:00") as in the examples.
I don't know in EN, but in IT both the examples get “Err:502”.

However you can close this bug, if you like, as the topic is treated more extensively in another bug (96140 and attachment 130160 [details]).
Comment 9 gmarco 2017-01-07 15:47:03 UTC
Created attachment 130240 [details]
IT and EN help screenshot
Comment 10 tommy27 2017-01-07 20:25:43 UTC
Ok, let't continue discussion at bug 96140.

status MOVED