[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #22 from gmarco  ---
(In reply to Buovjaga from comment #20)
> gmarco: is your request to write new content, like a summary about each of
> the format categories?

Here what I mean, even if it is only an example related to the specific topic
under consideration.

Your choice is to call it "Divisore" (MS calls it "Frazione" and you too in the
Guide) but you should still offer an explanation of what that type of
formatting means (not everyone is able to understand this and understand how to
use it).

In the current Guide it is impossible to find an effective help:
searching with the word "divisore" you get 
https://help.libreoffice.org/7.2/it/search?P=divisore  but nothing related to
the format,
you can go to
https://help.libreoffice.org/7.2/it/text/shared/01/05020300.html?=WRITER=WIN
... and then, from there?
searching INSTEAD with "frazione" you get
https://help.libreoffice.org/7.2/it/search?P=frazione
and then from here ("Inserire frazioni") you get also
https://help.libreoffice.org/7.2/it/text/scalc/guide/fraction_enter.html?=WRITER=WIN
but wherever  it is adopted the term "frazione" and, in any case, a valid
explanatory guide on the use of the format "Divisore"  is not available.

To better explain what I mean, I take for example the help offered by MS (in IT
but it should also be found in EN):
https://support.microsoft.com/it-it/office/numeric-formati-available-in-excel-0afe8f52-97db-41f1-b972-4b46e9f1e8d2
where you find "Frazione - Visualizza un numero come frazione, in base al tipo
di frazione specificato dall'utente." (translation: Fraction - Displays a
number as a fraction, based on the type of fraction specified by the user)
and then, in relation to "Frazione":
https://support.microsoft.com/it-it/office/visualizzare-i-numbers-as-fractions-0121ecac-1773-4f2d-8cd3-7db51fd83b77
where it is well explained how to display numbers as fractions.

It would also be useful to specify that the formats shown are only pre-set
examples, but the user can choose to customize the fractional format to his
liking (see attached sample.jpg for a cell containing the number 1,5).

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #21 from gmarco  ---
Created attachment 177526
  --> https://bugs.documentfoundation.org/attachment.cgi?id=177526=edit
Format screenshot

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

Buovjaga  changed:

   What|Removed |Added

 Status|RESOLVED|NEW
 Resolution|WORKSFORME  |---

--- Comment #20 from Buovjaga  ---
Please use direct links in the future to save time for others.

(In reply to gmarco from comment #18)
> Created attachment 177507 [details]
> help GUIDE 1°step

https://help.libreoffice.org/latest/en-US/text/shared/01/05020300.html?DbPAR=CALC

(In reply to gmarco from comment #19)
> Created attachment 177508 [details]
> help GUIDE 2°step

https://help.libreoffice.org/latest/en-US/text/scalc/main0105.html?DbPAR=CALC

So I understand gmarco's complaint to be about the help page not explaining
what the different formatting categories *are*. We have this page about
formats, but it is like a deep dive:
https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html?=CALC

gmarco: is your request to write new content, like a summary about each of the
format categories?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #19 from gmarco  ---
Created attachment 177508
  --> https://bugs.documentfoundation.org/attachment.cgi?id=177508=edit
help GUIDE 2°step

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

gmarco  changed:

   What|Removed |Added

 Attachment #177507|hel GUIDE 1°step|help GUIDE 1°step
description||

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #18 from gmarco  ---
Created attachment 177507
  --> https://bugs.documentfoundation.org/attachment.cgi?id=177507=edit
hel GUIDE 1°step

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

gmarco  changed:

   What|Removed |Added

 CC||gmmell...@inwind.it

--- Comment #17 from gmarco  ---
Created attachment 177506
  --> https://bugs.documentfoundation.org/attachment.cgi?id=177506=edit
calc CELL FORMAT screenshot

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #16 from gmarco  ---
Hi Olivier, I don't like to insist but I contest that it can be classified as
"worksforme".
It seems to me that, from 2017 to today, nothing substantial has changed: the
original problem has remained the same.
I will limit myself to just one example: suppose I want information and help on
the "Divisore" (in IT) format (from Format> Cells> Numbers) by clicking on
"Help" (see attachment "help.jpg").
What I find is disarming: misinformation and nothing useful (see attachments
"guida1" and "guida2": they are in IT but nothing changes in the EN version).
If you explain to me how an "apprentice" would acquire what he is looking for,
I will be grateful.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

Olivier Hallot  changed:

   What|Removed |Added

 Resolution|--- |WORKSFORME
 Status|NEW |RESOLVED

--- Comment #15 from Olivier Hallot  ---
Pressing F1 in dialog shown in attachment#1 shows the right Help page.

https://help.libreoffice.org/7.2/en-US/text/shared/01/05020300.html?System=UNIX=CALC=cui/ui/numberingformatpage/NumberingFormatPage#bm_id3150147

Version: 7.2.2.2 / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (en_US.UTF-8); UI: pt-BR
Calc: threaded

Closing - worksforme

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||2355

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #14 from gmarco  ---
(In reply to Buovjaga from comment #13)
> (In reply to gmarco from comment #12)
> > (In reply to Buovjaga from comment #11)
> > > The thing is, it downloads as an .odt for me, not as a .zip. So it is your
> > > browser.
> > 
> > Right, FIREFOX asks if I wish to open it with LO, but EDGE and Int.EXPLORER
> > download automatically as .zip (Who knows why?).
> 
> It is possible the real problem is the LibreOffice web server being
> incorrectly configured regarding the file types, example:
> https://blogs.msdn.microsoft.com/asiatech/2012/03/28/office-documents-will-
> be-recognized-as-zip-file-when-downloading-from-ie/

Really it seems the issue, thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #13 from Buovjaga  ---
(In reply to gmarco from comment #12)
> (In reply to Buovjaga from comment #11)
> > The thing is, it downloads as an .odt for me, not as a .zip. So it is your
> > browser.
> 
> Right, FIREFOX asks if I wish to open it with LO, but EDGE and Int.EXPLORER
> download automatically as .zip (Who knows why?).

It is possible the real problem is the LibreOffice web server being incorrectly
configured regarding the file types, example:
https://blogs.msdn.microsoft.com/asiatech/2012/03/28/office-documents-will-be-recognized-as-zip-file-when-downloading-from-ie/

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #12 from gmarco  ---
(In reply to Buovjaga from comment #11)
> The thing is, it downloads as an .odt for me, not as a .zip. So it is your
> browser.

Right, FIREFOX asks if I wish to open it with LO, but EDGE and Int.EXPLORER
download automatically as .zip (Who knows why?).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #11 from Buovjaga  ---
(In reply to gmarco from comment #10)
> Well, no need to rename the extension, I opened the file directly from WRITE
> and ... OK.
> But I think it is not a browser issue, the file that any browser would
> download .zip (usually a compressed folder to decompress), and the .zip
> extension has no association in Windows 10 that automatically decompresses
> it with a doubleclick.
> Here, too, it could be a matter of more explicit information, saying only
> "Open it in LibreOffice" is not quite explicit: any Windows user, seeing
> .zip is brought to click the file to decompress it.

The thing is, it downloads as an .odt for me, not as a .zip. So it is your
browser.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #10 from gmarco  ---
(In reply to Buovjaga from comment #9)
> ODF files are .zips in disguise, just like Microsoft's OOXML files. Your
> browsers are somehow treating them only as archives and not recognizing them
> as documents.
> 
> Please rename the .zip extension back to .odt. In the future you can
> consider using a browser like Firefox.

Well, no need to rename the extension, I opened the file directly from WRITE
and ... OK.
But I think it is not a browser issue, the file that any browser would download
.zip (usually a compressed folder to decompress), and the .zip extension has no
association in Windows 10 that automatically decompresses it with a
doubleclick.
Here, too, it could be a matter of more explicit information, saying only "Open
it in LibreOffice" is not quite explicit: any Windows user, seeing .zip is
brought to click the file to decompress it.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #9 from Buovjaga  ---
(In reply to gmarco from comment #7)
> What do you intend (which it actually is, but yeah..)?
> I confirm it is .zip as said (also re-downloading), my usual browser is EDGE
> (Win10) but Int.Expl. too download a .zip and the content is (look at the
> attachment).
> 
> PS: ... but all this  has nothing to do with the bug, can be deleted?

ODF files are .zips in disguise, just like Microsoft's OOXML files. Your
browsers are somehow treating them only as archives and not recognizing them as
documents.

Please rename the .zip extension back to .odt. In the future you can consider
using a browser like Firefox.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #8 from gmarco  ---
Created attachment 131950
  --> https://bugs.documentfoundation.org/attachment.cgi?id=131950=edit
downloaded help

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #7 from gmarco  ---
(In reply to Buovjaga from comment #6)
> (In reply to gmarco from comment #5)
> It's not .zip, but .odt. Your browser must have somehow thought it is a .zip
> file (which it actually is, but yeah..).

What do you intend (which it actually is, but yeah..)?
I confirm it is .zip as said (also re-downloading), my usual browser is EDGE
(Win10) but Int.Expl. too download a .zip and the content is (look at the
attachment).

PS: ... but all this  has nothing to do with the bug, can be deleted?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #6 from Buovjaga  ---
(In reply to gmarco from comment #5)
> I downloaded the example (template-help.zip) but inside I do not see any
> files I can open in LO ?

It's not .zip, but .odt. Your browser must have somehow thought it is a .zip
file (which it actually is, but yeah..).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #5 from gmarco  ---
(In reply to Buovjaga from comment #4)
> (In reply to gmarco from comment #0)
> > When will a complete revision of help with alignment to reality?
> 
> You make so many reports about docs that I think you should join the team:
> http://documentation.libreoffice.org/en/join-community/
> 
> -> NEW

Hi Buovjaga,
I make extensive use of CALC and I happen to experience some malfunctioning or
having to look for a new solution method resorting to the help. I happen to not
find adequate explanation or lack of examples or anomalies in the text pages.
In both cases I take up the report, but unfortunately I do not have enough time
available to also ensure the management of possible help correction that
otherwise would do it with pleasure.
I have read the link provided and reading "Update our LibreOffice Help contents
... Click here to know how to write a help page." out of curiosity I clicked
and found
<< The very easy way, for newcomers
Short summary: Write a help page in a LibreOffice document and send it to us.
We will turn it into a help page, freeing you of the internals of creating XML
help page.
Detailed instructions:
Donwload this example of a help page template into your computer
Open it in LibreOffice
Insert contents by Following the instructions in the document
Review spelling and grammar, check readability
Send the document to us >>
I downloaded the example (template-help.zip) but inside I do not see any files
I can open in LO ?




Suggerisci una modifica


Google Traduttore per il Business:Translator ToolkitTraduttore di siti
webStrumento a supporto dell'export
Informazioni su Google TraduttoreCommunityPer cellulari


Tutto su GooglePrivacy e

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||todven...@suomi24.fi
 Ever confirmed|0   |1
   Severity|normal  |minor

--- Comment #4 from Buovjaga  ---
(In reply to gmarco from comment #0)
> When will a complete revision of help with alignment to reality?

You make so many reports about docs that I think you should join the team:
http://documentation.libreoffice.org/en/join-community/

-> NEW

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #3 from gmarco  ---
Created attachment 131920
  --> https://bugs.documentfoundation.org/attachment.cgi?id=131920=edit
CALC-cell format 4

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #2 from gmarco  ---
Created attachment 131919
  --> https://bugs.documentfoundation.org/attachment.cgi?id=131919=edit
CALC-cell format 3

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106560] CALC cell formatting

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106560

--- Comment #1 from gmarco  ---
Created attachment 131918
  --> https://bugs.documentfoundation.org/attachment.cgi?id=131918=edit
CALC-cell format 2

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs