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

James D Howard <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #2 from James D Howard <[email protected]> ---
Regrettably, a saved file example will not show the bug, because the editing
process destroys the presence of the <HT> (0x09 tab).  The following detailed
process easily and repeatably shows the editing bug.

1.) Start LibreOffice Calc from Windows Start menu icon
   -- Calc shows initial, blank, new unnamed spreadsheet
   -- Allow cells to remain in default formatting
2.) Select Calc spreadsheet cell A1 and enter some text
   -- Enter "ABCD"
2.) Start a plain text editor like MSFT Notepad
   -- Enter in text "abc<HT>def"
      -- where <HT> is 0x09 an ASCII horizonal tab ^I
   -- Visual effect of tab <HT> between 'c' and 'd' clearly visible
      -- multi-width whitespace shown between 'c' and 'd' verifies
            <HT> entry
   -- Select and [Ctrl]+C (copy) the <HT> within the text (1 char)
3.) Again, select Calc spreadsheet cell A1
   -- Note: Do this by double-click while cursor is pointing inside the cell
      -- Activates in-place, on-screen intra-cell editing
      -- Cursor turns to vertical bar text edit cursor
   -- Use left- or right-arrow keys (if needed) to move vertical bar text
         edit cursor to be between the 'B' and 'C'
   -- Do a 'paste' [Ctrl]+V into the cell, placing <HT> between 'B' and 'C'
      -- 'wide' whitespace now visible in cell
      -- Cell cursor remains in text-entry mode
   -- Additional verification of <HT>:
      -- Move text entry cursor to left of cell with [Home] key
      -- Again use [Ctrl]+V paste
      -- see visual effect of <HT>
      -- Cell cursor remains in text-entry mode
   -- Triple click on cell to get all cell text selected
   -- Copy selected text by either:
      -- Right-click on cell to get context menu & use [Copy] item, or
      -- [Ctrl]+C copy keyboard command
4.) Verify <HT> in cell's entry data
   -- Move GUI focus back to text editor
   -- Do [Ctrl]+V on a new line in text editor
   -- Note that visual effect of <HT> is present
      -- If your editor can show non-printing glyphs, you will see "tab"
            indicator(s)
5.) Return focus to Calc window
   -- (Should still see cell's selection highlight of all text in cell)
   -- Use cursor-and-click to select another cell
   -- Note: entered text in cell changes, eliminating <HT> effect
         and turns <HT> chars into spaces
6.) At this point, the user's desired text entry has been damaged/destroyed,
      and no longer contains <HT>

This is distinctly UN-like Excel, which preserves <HT>

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to