X
Tippen Sie hierhin, um die Version dieser Website für Mobilgeräte aufzurufen.

Hilfeforum

Firefox adds a char(10) to cell content under repeatable conditions in google sheets. Does not happen with chrome.

Veröffentlicht

This was first reported here original post and verified by Mchall and me.

The issue arises with the following steps

   find a cell with text (not formula)
   place the cursor in the edit line (formula bar)
   backspace to remove all of the text
   type in new text
   hit enter

A new line, char(10) is inserted after the text. Confirmed with a find function.

It did this with Firefox but not Chrome. Reported in Google sheets forum title "Why are line breaks being added to cells randomly" Can't see how to add link here.

This was first reported here original post and verified by Mchall and me. The issue arises with the following steps find a cell with text (not formula) place the cursor in the edit line (formula bar) backspace to remove all of the text type in new text hit enter A new line, char(10) is inserted after the text. Confirmed with a find function. It did this with Firefox but not Chrome. Reported in Google sheets forum title "Why are line breaks being added to cells randomly" Can't see how to add link here.
Zitieren

Mehr Details zum System

Installierte Plugins

Firefox Multi-Account Containers; Messenger for Google™ Hangouts; uBlock Origin; ImTranslator: Translator, Dictionary, TTS (disabled)

Anwendung

  • Firefox 70.0.1
  • User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:70.0) Gecko/20100101 Firefox/70.0
  • Hilfe-URL: https://support.mozilla.org/1/firefox/70.0.1/WINNT/en-US/

Erweiterungen

  • Amazon.com 1.1 (amazondotcom@search.mozilla.org)
  • Bing 1.0 (bing@search.mozilla.org)
  • DuckDuckGo 1.0 (ddg@search.mozilla.org)
  • eBay 1.0 (ebay@search.mozilla.org)
  • Firefox Multi-Account Containers 6.1.1 (@testpilot-containers)
  • Google 1.0 (google@search.mozilla.org)
  • Messenger for Google™ Hangouts 0.1.9 (jid1-uqbSKwXpf2K6yl@jetpack)
  • Twitter 1.0 (twitter@search.mozilla.org)
  • uBlock Origin 1.23.0 (uBlock0@raymondhill.net)
  • Wikipedia (en) 1.0 (wikipedia@search.mozilla.org)
  • ImTranslator: Translator, Dictionary, TTS 15.37 ({9AA46F4F-4DC7-4c06-97AF-5035170634FE}) (inaktiv)

JavaScript

  • incrementalGCEnabled: True

Grafiken

  • adapterDescription: Intel(R) HD Graphics
  • adapterDescription2: NVIDIA GeForce GT 520M
  • adapterDeviceID: 0x0046
  • adapterDeviceID2: 0x0df7
  • adapterDrivers: igdumd64 igd10umd64 igdumdx32 igd10umd32
  • adapterDrivers2: C:\WINDOWS\System32\DriverStore\FileRepository\nvacwu.inf_amd64_9d2734742a07f3cf\nvldumdx.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nvacwu.inf_amd64_9d2734742a07f3cf\nvldumdx.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nvacwu.inf_amd64_9d2734742a07f3cf\nvldumdx.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nvacwu.inf_amd64_9d2734742a07f3cf\nvldumdx.dll C:\WINDOWS\System32\DriverStore\FileRepository\nvacwu.inf_amd64_9d2734742a07f3cf\nvldumd.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nvacwu.inf_amd64_9d2734742a07f3cf\nvldumd.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nvacwu.inf_amd64_9d2734742a07f3cf\nvldumd.dll,C:\WINDOWS\System32\DriverStore\FileRepository\nvacwu.inf_amd64_9d2734742a07f3cf\nvldumd.dll
  • adapterRAM: Unknown
  • adapterRAM2: 1024
  • adapterSubsysID: 04881025
  • adapterSubsysID2: 04881025
  • adapterVendorID: 0x8086
  • adapterVendorID2: 0x10de
  • clearTypeParameters: Gamma: 1.8 Pixel Structure: RGB ClearType Level: 100 Enhanced Contrast: 50
  • contentUsesTiling: False
  • crashGuards: []
  • direct2DEnabled: True
  • directWriteEnabled: True
  • directWriteVersion: 10.0.18362.356
  • driverDate: 11-26-2012
  • driverDate2: 5-1-2017
  • driverVendor:
  • driverVendor2:
  • driverVersion: 8.15.10.2900
  • driverVersion2: 22.21.13.8205
  • failures: [u'CP+[GFX1-]: [D2D1.1] 4CreateBitmap failure Size(300,10790) Code: 0x80070057 format 0']
  • featureLog: {u'fallbacks': [], u'features': [{u'status': u'available', u'description': u'Compositing', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'HW_COMPOSITING'}, {u'status': u'available', u'description': u'Direct3D11 Compositing', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'D3D11_COMPOSITING'}, {u'status': u'available', u'description': u'Direct2D', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'DIRECT2D'}, {u'status': u'available', u'description': u'Direct3D11 hardware ANGLE', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'D3D11_HW_ANGLE'}, {u'status': u'available', u'description': u'GPU Process', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'GPU_PROCESS'}, {u'status': u'opt-in', u'description': u'WebRender', u'log': [{u'status': u'opt-in', u'message': u'WebRender is an opt-in feature', u'type': u'default'}], u'name': u'WEBRENDER'}, {u'status': u'blacklisted', u'description': u'WebRender qualified', u'log': [{u'status': u'available', u'type': u'default'}, {u'status': u'blacklisted', u'message': u'No qualified hardware', u'type': u'env'}], u'name': u'WEBRENDER_QUALIFIED'}, {u'status': u'available', u'description': u'Off Main Thread Painting', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'OMTP'}, {u'status': u'available', u'description': u'Advanced Layers', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'ADVANCED_LAYERS'}]}
  • indices: [0]
  • info: {u'AzureContentBackend (UI Process)': u'skia', u'CMSOutputProfile': u'AAAMSExpbm8CEAAAbW50clJHQiBYWVogB84AAgAJAAYAMQAAYWNzcE1TRlQAAAAASUVDIHNSR0IAAAAAAAAAAAAAAAAAAPbWAAEAAAAA0y1IUCAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAARY3BydAAAAVAAAAAzZGVzYwAAAYQAAABsd3RwdAAAAfAAAAAUYmtwdAAAAgQAAAAUclhZWgAAAhgAAAAUZ1hZWgAAAiwAAAAUYlhZWgAAAkAAAAAUZG1uZAAAAlQAAABwZG1kZAAAAsQAAACIdnVlZAAAA0wAAACGdmlldwAAA9QAAAAkbHVtaQAAA/gAAAAUbWVhcwAABAwAAAAkdGVjaAAABDAAAAAMclRSQwAABDwAAAgMZ1RSQwAABDwAAAgMYlRSQwAABDwAAAgMdGV4dAAAAABDb3B5cmlnaHQgKGMpIDE5OTggSGV3bGV0dC1QYWNrYXJkIENvbXBhbnkAAGRlc2MAAAAAAAAAEnNSR0IgSUVDNjE5NjYtMi4xAAAAAAAAAAAAAAASc1JHQiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFhZWiAAAAAAAADzUQABAAAAARbMWFlaIAAAAAAAAAAAAAAAAAAAAABYWVogAAAAAAAAb6IAADj1AAADkFhZWiAAAAAAAABimQAAt4UAABjaWFlaIAAAAAAAACSgAAAPhAAAts9kZXNjAAAAAAAAABZJRUMgaHR0cDovL3d3dy5pZWMuY2gAAAAAAAAAAAAAABZJRUMgaHR0cDovL3d3dy5pZWMuY2gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZGVzYwAAAAAAAAAuSUVDIDYxOTY2LTIuMSBEZWZhdWx0IFJHQiBjb2xvdXIgc3BhY2UgLSBzUkdCAAAAAAAAAAAAAAAuSUVDIDYxOTY2LTIuMSBEZWZhdWx0IFJHQiBjb2xvdXIgc3BhY2UgLSBzUkdCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGRlc2MAAAAAAAAALFJlZmVyZW5jZSBWaWV3aW5nIENvbmRpdGlvbiBpbiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAACxSZWZlcmVuY2UgVmlld2luZyBDb25kaXRpb24gaW4gSUVDNjE5NjYtMi4xAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB2aWV3AAAAAAATpP4AFF8uABDPFAAD7cwABBMLAANcngAAAAFYWVogAAAAAABMCVYAUAAAAFcf521lYXMAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAKPAAAAAnNpZyAAAAAAQ1JUIGN1cnYAAAAAAAAEAAAAAAUACgAPABQAGQAeACMAKAAtADIANwA7AEAARQBKAE8AVABZAF4AYwBoAG0AcgB3AHwAgQCGAIsAkACVAJoAnwCkAKkArgCyALcAvADBAMYAywDQANUA2wDgAOUA6wDwAPYA+wEBAQcBDQETARkBHwElASsBMgE4AT4BRQFMAVIBWQFgAWcBbgF1AXwBgwGLAZIBmgGhAakBsQG5AcEByQHRAdkB4QHpAfIB+gIDAgwCFAIdAiYCLwI4AkECSwJUAl0CZwJxAnoChAKOApgCogKsArYCwQLLAtUC4ALrAvUDAAMLAxYDIQMtAzgDQwNPA1oDZgNyA34DigOWA6IDrgO6A8cD0wPgA+wD+QQGBBMEIAQtBDsESARVBGMEcQR+BIwEmgSoBLYExATTBOEE8AT+BQ0FHAUrBToFSQVYBWcFdwWGBZYFpgW1BcUF1QXlBfYGBgYWBicGNwZIBlkGagZ7BowGnQavBsAG0QbjBvUHBwcZBysHPQdPB2EHdAeGB5kHrAe/B9IH5Qf4CAsIHwgyCEYIWghuCIIIlgiqCL4I0gjnCPsJEAklCToJTwlkCXkJjwmkCboJzwnlCfsKEQonCj0KVApqCoEKmAquCsUK3ArzCwsLIgs5C1ELaQuAC5gLsAvIC+EL+QwSDCoMQwxcDHUMjgynDMAM2QzzDQ0NJg1ADVoNdA2ODakNww3eDfgOEw4uDkkOZA5/DpsOtg7SDu4PCQ8lD0EPXg96D5YPsw/PD+wQCRAmEEMQYRB+EJsQuRDXEPURExExEU8RbRGMEaoRyRHoEgcSJhJFEmQShBKjEsMS4xMDEyMTQxNjE4MTpBPFE+UUBhQnFEkUahSLFK0UzhTwFRIVNBVWFXgVmxW9FeAWAxYmFkkWbBaPFrIW1hb6Fx0XQRdlF4kXrhfSF/cYGxhAGGUYihivGNUY+hkgGUUZaxmRGbcZ3RoEGioaURp3Gp4axRrsGxQbOxtjG4obshvaHAIcKhxSHHscoxzMHPUdHh1HHXAdmR3DHeweFh5AHmoelB6+HukfEx8+H2kflB+/H+ogFSBBIGwgmCDEIPAhHCFIIXUhoSHOIfsiJyJVIoIiryLdIwojOCNmI5QjwiPwJB8kTSR8JKsk2iUJJTglaCWXJccl9yYnJlcmhya3JugnGCdJJ3onqyfcKA0oPyhxKKIo1CkGKTgpaymdKdAqAio1KmgqmyrPKwIrNitpK50r0SwFLDksbiyiLNctDC1BLXYtqy3hLhYuTC6CLrcu7i8kL1ovkS/HL/4wNTBsMKQw2zESMUoxgjG6MfIyKjJjMpsy1DMNM0YzfzO4M/E0KzRlNJ402DUTNU01hzXCNf02NzZyNq426TckN2A3nDfXOBQ4UDiMOMg5BTlCOX85vDn5OjY6dDqyOu87LTtrO6o76DwnPGU8pDzjPSI9YT2hPeA+ID5gPqA+4D8hP2E/oj/iQCNAZECmQOdBKUFqQaxB7kIwQnJCtUL3QzpDfUPARANER0SKRM5FEkVVRZpF3kYiRmdGq0bwRzVHe0fASAVIS0iRSNdJHUljSalJ8Eo3Sn1KxEsMS1NLmkviTCpMcky6TQJNSk2TTdxOJU5uTrdPAE9JT5NP3VAnUHFQu1EGUVBRm1HmUjFSfFLHUxNTX1OqU/ZUQlSPVNtVKFV1VcJWD1ZcVqlW91dEV5JX4FgvWH1Yy1kaWWlZuFoHWlZaplr1W0VblVvlXDVchlzWXSddeF3JXhpebF69Xw9fYV+zYAVgV2CqYPxhT2GiYfViSWKcYvBjQ2OXY+tkQGSUZOllPWWSZedmPWaSZuhnPWeTZ+loP2iWaOxpQ2maafFqSGqfavdrT2una/9sV2yvbQhtYG25bhJua27Ebx5veG/RcCtwhnDgcTpxlXHwcktypnMBc11zuHQUdHB0zHUodYV14XY+dpt2+HdWd7N4EXhueMx5KnmJeed6RnqlewR7Y3vCfCF8gXzhfUF9oX4BfmJ+wn8jf4R/5YBHgKiBCoFrgc2CMIKSgvSDV4O6hB2EgITjhUeFq4YOhnKG14c7h5+IBIhpiM6JM4mZif6KZIrKizCLlov8jGOMyo0xjZiN/45mjs6PNo+ekAaQbpDWkT+RqJIRknqS45NNk7aUIJSKlPSVX5XJljSWn5cKl3WX4JhMmLiZJJmQmfyaaJrVm0Kbr5wcnImc951kndKeQJ6unx2fi5/6oGmg2KFHobaiJqKWowajdqPmpFakx6U4pammGqaLpv2nbqfgqFKoxKk3qamqHKqPqwKrdavprFys0K1ErbiuLa6hrxavi7AAsHWw6rFgsdayS7LCszizrrQltJy1E7WKtgG2ebbwt2i34LhZuNG5SrnCuju6tbsuu6e8IbybvRW9j74KvoS+/796v/XAcMDswWfB48JfwtvDWMPUxFHEzsVLxcjGRsbDx0HHv8g9yLzJOsm5yjjKt8s2y7bMNcy1zTXNtc42zrbPN8+40DnQutE80b7SP9LB00TTxtRJ1MvVTtXR1lXW2Ndc1+DYZNjo2WzZ8dp22vvbgNwF3IrdEN2W3hzeot8p36/gNuC94UThzOJT4tvjY+Pr5HPk/OWE5g3mlucf56noMui86Ubp0Opb6uXrcOv77IbtEe2c7ijutO9A78zwWPDl8XLx//KM8xnzp/Q09ML1UPXe9m32+/eK+Bn4qPk4+cf6V/rn+3f8B/yY/Sn9uv5L/tz/bf//', u'AzureCanvasBackend (UI Process)': u'skia', u'ApzWheelInput': 1, u'ApzDragInput': 1, u'ApzKeyboardInput': 1, u'AzureFallbackCanvasBackend (UI Process)': u'none', u'ApzAutoscrollInput': 1, u'AzureCanvasBackend': u'direct2d 1.1', u'AzureContentBackend': u'direct2d 1.1'}
  • isGPU2Active: False
  • numAcceleratedWindows: 2
  • numTotalWindows: 2
  • offMainThreadPaintEnabled: True
  • offMainThreadPaintWorkerCount: 3
  • targetFrameRate: 60
  • usesTiling: False
  • webgl1DriverExtensions: GL_ANGLE_client_arrays GL_ANGLE_depth_texture GL_ANGLE_explicit_context GL_ANGLE_explicit_context_gles1 GL_ANGLE_framebuffer_blit GL_ANGLE_framebuffer_multisample GL_ANGLE_instanced_arrays GL_ANGLE_lossy_etc_decode GL_ANGLE_memory_size GL_ANGLE_multi_draw GL_ANGLE_pack_reverse_row_order GL_ANGLE_program_cache_control GL_ANGLE_provoking_vertex GL_ANGLE_request_extension GL_ANGLE_robust_client_memory GL_ANGLE_texture_compression_dxt3 GL_ANGLE_texture_compression_dxt5 GL_ANGLE_texture_usage GL_ANGLE_translated_shader_source GL_CHROMIUM_bind_generates_resource GL_CHROMIUM_bind_uniform_location GL_CHROMIUM_color_buffer_float_rgb GL_CHROMIUM_color_buffer_float_rgba GL_CHROMIUM_copy_compressed_texture GL_CHROMIUM_copy_texture GL_CHROMIUM_sync_query GL_EXT_blend_func_extended GL_EXT_blend_minmax GL_EXT_color_buffer_half_float GL_EXT_debug_marker GL_EXT_discard_framebuffer GL_EXT_disjoint_timer_query GL_EXT_draw_buffers GL_EXT_float_blend GL_EXT_frag_depth GL_EXT_instanced_arrays GL_EXT_map_buffer_range GL_EXT_occlusion_query_boolean GL_EXT_read_format_bgra GL_EXT_robustness GL_EXT_sRGB GL_EXT_shader_texture_lod GL_EXT_texture_compression_dxt1 GL_EXT_texture_compression_s3tc_srgb GL_EXT_texture_filter_anisotropic GL_EXT_texture_format_BGRA8888 GL_EXT_texture_rg GL_EXT_texture_storage GL_EXT_unpack_subimage GL_KHR_debug GL_KHR_parallel_shader_compile GL_KHR_robust_buffer_access_behavior GL_NV_EGL_stream_consumer_external GL_NV_fence GL_NV_pack_subimage GL_NV_pixel_buffer_object GL_OES_EGL_image GL_OES_EGL_image_external GL_OES_compressed_ETC1_RGB8_texture GL_OES_depth32 GL_OES_element_index_uint GL_OES_get_program_binary GL_OES_mapbuffer GL_OES_packed_depth_stencil GL_OES_rgb8_rgba8 GL_OES_standard_derivatives GL_OES_surfaceless_context GL_OES_texture_border_clamp GL_OES_texture_float GL_OES_texture_float_linear GL_OES_texture_half_float GL_OES_texture_half_float_linear GL_OES_texture_npot GL_OES_vertex_array_object OES_compressed_EAC_R11_signed_texture OES_compressed_EAC_R11_unsigned_texture OES_compressed_EAC_RG11_signed_texture OES_compressed_EAC_RG11_unsigned_texture OES_compressed_ETC2_RGB8_texture OES_compressed_ETC2_RGBA8_texture OES_compressed_ETC2_punchthroughA_RGBA8_texture OES_compressed_ETC2_punchthroughA_sRGB8_alpha_texture OES_compressed_ETC2_sRGB8_alpha8_texture OES_compressed_ETC2_sRGB8_texture
  • webgl1Extensions: ANGLE_instanced_arrays EXT_blend_minmax EXT_color_buffer_half_float EXT_disjoint_timer_query EXT_float_blend EXT_frag_depth EXT_shader_texture_lod EXT_sRGB EXT_texture_filter_anisotropic OES_element_index_uint OES_standard_derivatives OES_texture_float OES_texture_float_linear OES_texture_half_float OES_texture_half_float_linear OES_vertex_array_object WEBGL_color_buffer_float WEBGL_compressed_texture_s3tc WEBGL_compressed_texture_s3tc_srgb WEBGL_debug_renderer_info WEBGL_debug_shaders WEBGL_depth_texture WEBGL_draw_buffers WEBGL_lose_context
  • webgl1Renderer: Google Inc. -- ANGLE (Intel(R) HD Graphics Direct3D11 vs_4_0 ps_4_0)
  • webgl1Version: OpenGL ES 2.0 (ANGLE 2.1.0.21dccd386996)
  • webgl1WSIInfo: EGL_VENDOR: Google Inc. (adapter LUID: 0000000000007db4) EGL_VERSION: 1.4 (ANGLE 2.1.0.21dccd386996) EGL_EXTENSIONS: EGL_EXT_create_context_robustness EGL_ANGLE_d3d_share_handle_client_buffer EGL_ANGLE_d3d_texture_client_buffer EGL_ANGLE_surface_d3d_texture_2d_share_handle EGL_ANGLE_query_surface_pointer EGL_ANGLE_window_fixed_size EGL_ANGLE_keyed_mutex EGL_ANGLE_surface_orientation EGL_ANGLE_direct_composition EGL_NV_post_sub_buffer EGL_KHR_create_context EGL_EXT_device_query EGL_KHR_image EGL_KHR_image_base EGL_KHR_gl_texture_2D_image EGL_KHR_gl_texture_cubemap_image EGL_KHR_gl_renderbuffer_image EGL_KHR_get_all_proc_addresses EGL_KHR_stream EGL_KHR_stream_consumer_gltexture EGL_NV_stream_consumer_gltexture_yuv EGL_ANGLE_flexible_surface_compatibility EGL_ANGLE_stream_producer_d3d_texture EGL_ANGLE_create_context_webgl_compatibility EGL_CHROMIUM_create_context_bind_generates_resource EGL_CHROMIUM_sync_control EGL_EXT_pixel_format_float EGL_KHR_surfaceless_context EGL_ANGLE_display_texture_share_group EGL_ANGLE_create_context_client_arrays EGL_ANGLE_program_cache_control EGL_ANGLE_robust_resource_initialization EGL_ANGLE_create_context_extensions_enabled EGL_ANDROID_blob_cache EGL_ANDROID_recordable EGL_EXTENSIONS(nullptr): EGL_EXT_client_extensions EGL_EXT_platform_base EGL_EXT_platform_device EGL_ANGLE_platform_angle EGL_ANGLE_platform_angle_d3d EGL_ANGLE_device_creation EGL_ANGLE_device_creation_d3d11 EGL_ANGLE_experimental_present_path EGL_KHR_client_get_all_proc_addresses EGL_KHR_debug EGL_ANGLE_explicit_context
  • webgl2DriverExtensions: -
  • webgl2Extensions: -
  • webgl2Renderer: WebGL creation failed: * tryANGLE * Exhausted GL driver options.
  • webgl2Version: -
  • webgl2WSIInfo: -
  • windowLayerManagerRemote: True
  • windowLayerManagerType: Direct3D 11
  • windowUsingAdvancedLayers: True

Veränderte Einstellungen

Verschiedenes

  • User JS: Nein
  • Barrierefreiheit: Nein

Fragesteller

sheets forum post Sheets forum post is here

[https://support.google.com/docs/thread/18235069?hl=en sheets forum post] Sheets forum post is here
Hat Ihnen das weitergeholfen?
Zitieren
cor-el
  • Top 10 Contributor
  • Moderator
17580 Lösungen 159070 Antworten
Veröffentlicht

I found an old bug from 4 years ago about this issue that has similar STR (delete all text and then enter new text), so this isn't recent.

  • Bug 1192656 - Random newlines entered in Google Sheets cells when pressing enter

(please do not comment in bug reports
https://bugzilla.mozilla.org/page.cgi?id=etiquette.html
)

I found an old bug from 4 years ago about this issue that has similar STR (delete all text and then enter new text), so this isn't recent. *[https://bugzilla.mozilla.org/show_bug.cgi?id=1192656#c14 Bug 1192656] - Random newlines entered in Google Sheets cells when pressing enter (<i>please do not comment in bug reports<br>https://bugzilla.mozilla.org/page.cgi?id=etiquette.html</i>)
Hat Ihnen das weitergeholfen? 1
Zitieren

Fragesteller

Kind of sounds like they thought it was fixed. I've had several posts from various OP regarding this problem in the google sheets forum. Any way to get the bug report active again?

Ed

Kind of sounds like they thought it was fixed. I've had several posts from various OP regarding this problem in the google sheets forum. Any way to get the bug report active again? Ed

Geändert am von hannahse

Hat Ihnen das weitergeholfen? 1
Zitieren
terebusspoony 0 Lösungen 1 Antworten
Veröffentlicht

Hilfreiche Antwort

I can replicate the bug in the exact conditions described above, and in other ways as well.

I don't need to edit the text in the formula bar, I can just select a cell and start typing, delete all the text with backspace, and then any "movement" out of the cell will cause a newline character to be added. That is, enter, tab or any of the directional keys will cause the same behavior.

A newline character being added is also happening without having to remove all of the text from the cell, but I can't find the exact cause.

I can replicate the bug in the exact conditions described above, and in other ways as well. I don't need to edit the text in the formula bar, I can just select a cell and start typing, delete all the text with backspace, and then any "movement" out of the cell will cause a newline character to be added. That is, enter, tab or any of the directional keys will cause the same behavior. A newline character being added is also happening without having to remove all of the text from the cell, but I can't find the exact cause.
Hat Ihnen das weitergeholfen? 3
Zitieren
NameName 0 Lösungen 1 Antworten
Veröffentlicht

I'm not sure what this forum's posting etiquette is, but I came here from the Google Sheets forum after experiencing the same issue. It is *maddening*. This glitch happens really frequently for me, probably because I edit my cells so much.

I use Sheets so much in my daily workflow, and the Android Firefox app is so much more buggy than Chrome, that I've switched back to using Chrome permanently unfortunately.

I'm not sure what this forum's posting etiquette is, but I came here from the Google Sheets forum after experiencing the same issue. It is *maddening*. This glitch happens really frequently for me, probably because I edit my cells so much. I use Sheets so much in my daily workflow, and the Android Firefox app is so much more buggy than Chrome, that I've switched back to using Chrome permanently unfortunately.
Hat Ihnen das weitergeholfen? 1
Zitieren
Rick 0 Lösungen 3 Antworten
Veröffentlicht

I have the same issue in Google sheets when using the newest version of Firefox and Windows 10. A new line being added in the cell after i press enter. Just like so many other Firefox users that have complained in the sheets forum. Others posted saying this bug appeared after the last Firefox update and I agree.

Earlier this year there was another annoying bug with the cursor not turning into a hand when dragging cells. This took months to get fixed.

Love Firefox and Google sheets but im going to have to replace one of them if these very annoying bugs keeps getting in the way of work.

I have the same issue in Google sheets when using the newest version of Firefox and Windows 10. A new line being added in the cell after i press enter. Just like so many other Firefox users that have complained in the sheets forum. Others posted saying this bug appeared after the last Firefox update and I agree. Earlier this year there was another annoying bug with the cursor not turning into a hand when dragging cells. This took months to get fixed. Love Firefox and Google sheets but im going to have to replace one of them if these very annoying bugs keeps getting in the way of work.
Hat Ihnen das weitergeholfen? 1
Zitieren
AlexFolland 0 Lösungen 2 Antworten
Veröffentlicht

This happens to me too, but it seems to only happen when editing cells I've never edited yet. After I've edited the cell and the Char(10) is added and I've removed it, it doesn't happen again when editing the same cell.

This happens to me too, but it seems to only happen when editing cells I've never edited yet. After I've edited the cell and the Char(10) is added and I've removed it, it doesn't happen again when editing the same cell.
Hat Ihnen das weitergeholfen?
Zitieren
Sami 0 Lösungen 1 Antworten
Veröffentlicht

This happens to me too on Firefox (desktop). Drives me nuts.

This happens to me too on Firefox (desktop). Drives me nuts.
Hat Ihnen das weitergeholfen?
Zitieren
jscher2000
  • Top 10 Contributor
8796 Lösungen 71953 Antworten
Veröffentlicht

Well, this is off-topic, but for the record:

Rick said

Earlier this year there was another annoying bug with the cursor not turning into a hand when dragging cells. This took months to get fixed.

Within days of when that was reported on this forum (thread), I filed a bug and that got fixed in the code base. It took another month to roll out to the regular release in Firefox 69.0. It's something Google could have fixed itself at any time by changing its CSS styling for the cursor from -moz-grab to grab, -moz-grabbing to grabbing.

Well, this is off-topic, but for the record: ''Rick [[#answer-1270634|said]]'' <blockquote> Earlier this year there was another annoying bug with the cursor not turning into a hand when dragging cells. This took months to get fixed. </blockquote> Within days of when that was reported on this forum ([https://support.mozilla.org/questions/1265668 thread]), I filed a bug and that got fixed in the code base. It took another month to roll out to the regular release in Firefox 69.0. It's something Google could have fixed itself at any time by changing its CSS styling for the cursor from -moz-grab to grab, -moz-grabbing to grabbing.
Hat Ihnen das weitergeholfen? 1
Zitieren
jscher2000
  • Top 10 Contributor
8796 Lösungen 71953 Antworten
Veröffentlicht

Hilfreiche Antwort

Sheets is a complex application. When you invoke the cell editor, Google's code positions a <div> element in the appropriate location with the contenteditable attribute set to true. This triggers "editor" code in the browser and apparently different editors behave differently in recent years.

In Firefox (and Edge), when you delete the entire text, an HTML line break element (<br>) is inserted. You can see that in this test page:

https://www.jeffersonscher.com/res/editor-newline.html

That may have been designed back in the day because otherwise the element would become invisible and difficult to editor further. That workaround isn't needed if the <div> is coded to avoid collapsing, but the behavior persists.

Apparently it used to work that way in Chrome, too, but not any more.

I'm not aware of a setting to change this behavior, or any urgent action to get it updated to match Chrome's change. Possibly an add-on or userscript could monitor for the Sheets cell editor containing nothing but the line break and remove it, but I haven't tried to create such a thing.

Sheets is a complex application. When you invoke the cell editor, Google's code positions a &lt;div&gt; element in the appropriate location with the '''contenteditable''' attribute set to true. This triggers "editor" code in the browser and apparently different editors behave differently in recent years. In Firefox (and Edge), when you delete the entire text, an HTML line break element (&lt;br&gt;) is inserted. You can see that in this test page: https://www.jeffersonscher.com/res/editor-newline.html That may have been designed back in the day because otherwise the element would become invisible and difficult to editor further. That workaround isn't needed if the &lt;div&gt; is coded to avoid collapsing, but the behavior persists. Apparently it [https://stackoverflow.com/questions/14638887/br-is-inserted-into-contenteditable-html-element-if-left-empty used to work that way in Chrome], too, but not any more. I'm not aware of a setting to change this behavior, or any urgent action to get it updated to match Chrome's change. Possibly an add-on or userscript could monitor for the Sheets cell editor containing nothing but the line break and remove it, but I haven't tried to create such a thing.
Hat Ihnen das weitergeholfen? 2
Zitieren
Rick 0 Lösungen 3 Antworten
Veröffentlicht

Thanks for the reply jscher2000. I understand the problem.

I think it's time to look for a new sheets application.

Simply googling "google sheets alternatives" will give you a list of alternatives to try:

  • Apple Numbers
  • Microsoft Excel
  • Zoho Sheet (Browser-Based)
  • Quip
  • LibreOffice
  • WPS Spreadsheets
  • Apache OpenOffice Calc
  • TabelloPDF

Im only familiar with Apache OpenOffice(free), Microsoft Excel and Apple Numbers but these have to be downloaded.

I really like the browser based application like Google Sheets so i made an account on Zoho Sheet. It's looks way nicer than Google sheets and have the same functions, if not more. Can be used on both Apple and Android devices.

So far i havent found any annoying bugs! Also its free. You just have to sign up with your email and download the old file from Google sheets and upload it to Zoho sheets.

You can do the same at any point if you want to go back to Google sheets.

Thanks for the reply jscher2000. I understand the problem. I think it's time to look for a new sheets application. Simply googling "google sheets alternatives" will give you a list of alternatives to try: * Apple Numbers * Microsoft Excel * Zoho Sheet (Browser-Based) * Quip * LibreOffice * WPS Spreadsheets * Apache OpenOffice Calc * TabelloPDF Im only familiar with Apache OpenOffice(free), Microsoft Excel and Apple Numbers but these have to be downloaded. I really like the browser based application like Google Sheets so i made an account on Zoho Sheet. It's looks way nicer than Google sheets and have the same functions, if not more. Can be used on both Apple and Android devices. So far i havent found any annoying bugs! Also its free. You just have to sign up with your email and download the old file from Google sheets and upload it to Zoho sheets. You can do the same at any point if you want to go back to Google sheets.
Hat Ihnen das weitergeholfen? 0
Zitieren
Rick 0 Lösungen 3 Antworten
Veröffentlicht

I just have to add that you can also get a free Microsoft Office online account that works in the web browser just like sheets. Downloading the office apps for your device is also free. Works well!

I just have to add that you can also get a free Microsoft Office online account that works in the web browser just like sheets. Downloading the office apps for your device is also free. Works well!
Hat Ihnen das weitergeholfen?
Zitieren
Stellen Sie eine Frage

Sie müssen sich mit Ihrem Benutzerkonto anmelden, um auf Beiträge zu antworten. Bitte stellen Sie eine neue Frage, wenn Sie noch kein Benutzerkonto haben.