<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Regression - scientific notation now where numbers were shown before - cell padding now requires 1 digit of free space before and after a number, or the cell goes in scientific notation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123739">123739</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Regression - scientific notation now where numbers were shown before - cell padding now requires 1 digit of free space before and after a number, or the cell goes in scientific notation
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>icerabbitje@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Case: Large and important Calc file going back 10 years, that was carefully
laid out and setup, back in LO 3.x, updated fine through the years, using exact
size width columns and Arial 6 to input about 36 columns and 44 rows, perfectly
rendered on screen.
Computer nor display have changed since OS X 10.12.
Updated to LO 546 last year, and all of sudden I have lots of number cells with
2E+05 3E+05 etc
Again, nothing changed to the computer setup, file, data, cell formatting, ...
only LO updated.
Upon investigation it seems that 1 digit's worth of free space is now required
in front and behind the actual number, or LO Calc goes all 2E+05 3E+05
Totally ineffective and unbelievable. The numbers fit just fine. Where is
programmed padding requirement suddenly coming from, that I now have to reduce
the formatting to Arial Narrow 5pt ?!
Steps to Reproduce:
1. Open file created back in 3.x 4.x with 0.30" columns and font type Arial 6pt
or 5pt, add numbers with 6 digits
2.
3.
Actual Results:
Six digits numbers are all rendered as 2E+05 3E+06 etc
Expected Results:
Render the numbers legibly as old fashioned numbers on screen
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
I don't know when this exactly came about. I use this important file
intermittently. For at least 8 years. Once in a while I would get a ### on
screen and the easy fix was to drop that cell from Arial 6 to Arial 5 and it
would show the number again.
Having to use Arial 5 Narrow is painful to the eyes ...
And if I could, I would add screenshots that clearly show it is not required to
go 5pt font because one could fit an 8 digit number in the box now !!!
Please fix it by lowering the padding requirement to what it was.
Please fix also drop the scientific notation method. It is undesirable to me.
#### stands out visually. 2E+05 does not.
I can be reached as <a href="mailto:icerabbitje@gmail.com">icerabbitje@gmail.com</a>
---------//// OPEN GL REPORT //// ----------
Renderer: Intel HD Graphics 4000 OpenGL Engine
Vendor: Intel Inc.
Memory: 1536
MB
Version: 4.1 INTEL-10.25.17
Device: Macmini6,2
Shading language version:
4.10
Max texture size: 16384 x 16384
Max vertex texture image units: 16
Max
texture image units: 16
Max geometry texture units: 16
Max anisotropic
filtering value: 16
Max viewport size: 16384 x 16384
Max Clip Distances: 8
Max
samples: 8
Extensions: 45
GL_ARB_tessellation_shader
GL_APPLE_texture_range
GL_EXT_framebuffer_multisample_blit_scaled
GL_ARB_viewport_array
GL_ARB_gpu_shader_fp64
GL_ARB_explicit_attrib_location
GL_NV_texture_barrier
GL_ARB_separate_shader_objects
GL_ARB_texture_storage
GL_ARB_gpu_shader5
GL_ARB_texture_swizzle
GL_EXT_texture_compression_s3tc
GL_ARB_texture_cube_map_array
GL_ARB_blend_func_extended
GL_ARB_vertex_attrib_64bit
GL_EXT_texture_sRGB_decode
GL_ARB_texture_gather
GL_EXT_texture_filter_anisotropic
GL_APPLE_row_bytes
GL_ARB_transform_feedback2
GL_ARB_transform_feedback3
GL_ARB_draw_indirect
GL_ARB_texture_query_lod
GL_ARB_draw_buffers_blend
GL_ARB_sample_shading
GL_ARB_internalformat_query
GL_ARB_timer_query
GL_ARB_shader_subroutine
GL_ATI_texture_mirror_once
GL_EXT_debug_marker
GL_APPLE_rgb_422
GL_ARB_vertex_type_2_10_10_10_rev
GL_EXT_debug_label
GL_ARB_texture_buffer_object_rgb32
GL_ARB_instanced_arrays
GL_APPLE_container_object_shareable
GL_ARB_ES2_compatibility
GL_APPLE_client_storage
GL_ARB_sampler_objects
GL_ARB_occlusion_query2
GL_ARB_shading_language_include
GL_ARB_texture_rgb10_a2ui
GL_APPLE_object_purgeable
GL_ARB_shader_bit_encoding
GL_APPLE_flush_render
Core features
v3.0 (100 % - 23/23)
v3.1 (100 % - 8/8)
v3.2 (100 % - 10/10)
v3.3 (100 % -
10/10)
v4.0 (100 % - 14/14)
v4.1 (100 % - 7/7)
v4.2 (15 % - 2/13)
v4.3 (0 % -
0/23)
v4.4 (0 % - 0/10)
v4.5 (0 % - 0/11)
v4.6 (0 % - 0/11)
vARB 2015 (0 % -
0/12)
OpenGL driver version check (Current: 4.1 INTEL-10.25.17, Latest known: ):
Latest version of display drivers found
According the database, you are running
the latest display drivers for your video card.
Extension verification:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>