[Libreoffice-bugs] [Bug 101508] no possibility to convert as number imported fields into text format

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #6 from Buovjaga  ---
(In reply to Jean-Baptiste Faure from comment #5)
> I propose to close this bug report as NotABug.

Yep, that seems appropriate as no response from reporter to Cor's question.

-- 
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 101508] no possibility to convert as number imported fields into text format

[bugzilla-daemon]

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

Jean-Baptiste Faure  changed:

   What|Removed |Added

 CC||jbfa...@libreoffice.org

--- Comment #5 from Jean-Baptiste Faure  ---
I do not understand the problem, if you are not happy with the standard number
format, use # ##0 or 0 format instead.
That said the standard format for numbers has the good idea to generally fit in
the default cell width, when the 0 format will give ### if the cell is not wide
enough which is generally the case with big numbers like in your example.

I propose to close this bug report as NotABug.

Best regards. JBF

-- 
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 101508] no possibility to convert as number imported fields into text format

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

Version|5.1.2.2 release |Inherited From OOo

--- Comment #4 from Cor Nouws  ---
(In reply to Dominik Lenné from comment #3)

> OTOH people expect that a format function does what it sais it does. So a
> possibility would be to place a remark into the dialog something like "Does
> not work for imported data. Format can be defined during import process."

Then that would only apply for cells with text formatting..
Would you have a smart suggestion on in what situations how to inform the user?
E.g. formatting cell(s) of which one or more has text formatting (although
Format > Cells may highlight Number..) and when the user applies different
formatting that then he gets a pop-up explaining...

-- 
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 101508] no possibility to convert as number imported fields into text format

[bugzilla-daemon]

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

--- Comment #3 from Dominik Lenné  ---
(In reply to Buovjaga from comment #1)
> ..and formatted as number or text? If you want to have it as text, you can
> choose the column in the import dialog and change the Column type to Text.

Thanks for the answer. Yes this is a way to avoid the problem in the first
place, and is really very clever thought out.

OTOH people expect that a format function does what it sais it does. So a
possibility would be to place a remark into the dialog something like "Does not
work for imported data. Format can be defined during import process."

-- 
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 101508] no possibility to convert as number imported fields into text format

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl

--- Comment #2 from Cor Nouws  ---
(In reply to Buovjaga from comment #1)
> (In reply to Dominik Lenné from comment #0)
> > expected result:
> > field is displayed as the original digit string
> 
> ..and formatted as number or text? If you want to have it as text, you can
> choose the column in the import dialog and change the Column type to Text.

and then use this one
 
http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates
;)

-- 
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 101508] no possibility to convert as number imported fields into text format

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #1 from Buovjaga  ---
(In reply to Dominik Lenné from comment #0)
> expected result:
> field is displayed as the original digit string

..and formatted as number or text? If you want to have it as text, you can
choose the column in the import dialog and change the Column type to Text.

-- 
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