[Libreoffice-bugs] [Bug 136973] Calc: Long (19 digit integer) Numbers imported from .CSV file as Text appear to be a number though it is too long to be represented as a number

2021-03-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136973

Ming Hua  changed:

   What|Removed |Added

 Resolution|FIXED   |WORKSFORME

--- Comment #5 from Ming Hua  ---
(In reply to John Murrell from comment #4)
> It looks as though something has been fixed as the bug no longer exists in
> version:
> 
> Version: 7.1.1.2 / LibreOffice Community
Thanks for testing.  Changing status to WORKSFORME (FIXED usually means a
specific commit can be identified as fixing the issue).

-- 
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 136973] Calc: Long (19 digit integer) Numbers imported from .CSV file as Text appear to be a number though it is too long to be represented as a number

2021-03-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136973

John Murrell  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |FIXED

--- Comment #4 from John Murrell  ---
It looks as though something has been fixed as the bug no longer exists in
version:

Version: 7.1.1.2 / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Flatpak
Calc: threaded

-- 
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 136973] Calc: Long (19 digit integer) Numbers imported from .CSV file as Text appear to be a number though it is too long to be represented as a number

2021-03-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136973

--- Comment #3 from QA Administrators  ---
Dear John Murrell,

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.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping

-- 
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 136973] Calc: Long (19 digit integer) Numbers imported from .CSV file as Text appear to be a number though it is too long to be represented as a number

2020-09-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136973

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg
 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #2 from m.a.riosv  ---
Selecting the column as text, works fine for me, with your sample text, pasted
as non formatted.
Version: 7.1.0.0.alpha0+ (x64)
Build ID: dba1a27be2438b5dbd1f8d253acb3850c9c044da
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL

But maybe attaching a sample file where you reproduce the issue it's the better
for test.

-- 
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 136973] Calc: Long (19 digit integer) Numbers imported from .CSV file as Text appear to be a number though it is too long to be represented as a number

2020-09-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136973

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Blocks||109236


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109236
[Bug 109236] [META] CSV import bugs and enhancements
-- 
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 136973] Calc: Long (19 digit integer) Numbers imported from .CSV file as Text appear to be a number though it is too long to be represented as a number

2020-09-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136973

--- Comment #1 from John Murrell  ---
I have tried this again and while the import type for the 19 digit integer was
selected as text when imported the cell format shows it as a 19 digit number
despite the text selection in the import wizard.

If the imported 19 digit integers are formatted as text using cell - format -
text it appears that calc then believes they are text and you can concatenate
them as expected.

It appears the problem is somewhere between the import wizard and calc itself.
The selected text format is being over written as it looks like a number even
though it is too large to be shown.

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