Put TAB in a cell

[carlmclark]

Is there a way to disable the interpretation of the TAB key and let it pass through literally during cell data input?

[JohnSUN-Pensioner]

Why not?
You can, for example, paste a tab character in a blank document in Notepad, copy it to the clipboard, and as you type text into the cell, press Ctrl+V in the right places.
Or you can enter text in a cell as a formula of the form

Code: Select all

="Two Beers"&CHAR(9)&"Or"&CHAR(9)&"Not Two Beers?"

where CHAR(9) is the tab character
This is not an exhaustive list of features, but I'm just wondering - why do you need such an opportunity?

[Zizi64]

Here is a macro solution. Just copy/paste the macro code into MyMacros/Standard library/Module1 and then assign it the macro "cell_TAB" to a free hotkey like the Ctrl-T (or other).
The macro will insert a TAB character into the cursor position.

Code: Select all

sub cell_TAB
insert_a_char(CHR(9))
end sub


'*************************************************************************

sub insert_a_char(SpecChar as string)
rem ----------------------------------------------------------------------
rem define variables
dim document   as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
'dim args1(0) as new com.sun.star.beans.PropertyValue
'args1(0).Name = "Text"
'args1(0).Value = SpecChar
'dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args1())
dim args2(0) as new com.sun.star.beans.PropertyValue
args2(0).Name = "Symbols"
args2(0).Value = SpecChar

dispatcher.executeDispatch(document, ".uno:InsertSymbol", "", 0, args2())
end sub