[Solved] Converting to text

Discuss the word processor

[Solved] Converting to text

Postby oneota » Mon Jun 17, 2019 9:53 am

I have made a simple m x n table into which I want to enter letters, numbers and symbols. But OO interprets the table as an interactive spreadsheet. When I went to F1 and entered 'convert to text,' all the sub-sections (i.e., entries on the fith half of the screen) were for converting text, not TO text. How do I disable this sorcerer's broom?
Last edited by Hagar Delest on Mon Jun 17, 2019 8:50 pm, edited 1 time in total.
Reason: tagged solved
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: converting to text

Postby robleyd » Mon Jun 17, 2019 10:11 am

interprets the table as an interactive spreadsheet.


What sort of data are you entering, and what is happening to it? How did you add the table - via Ctrl+F12 or Table | Insert | Table ?
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2932
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: converting to text

Postby Villeroy » Mon Jun 17, 2019 10:42 am

Use the indexed search when the other search fails and vice versa.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27095
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: converting to text

Postby oneota » Mon Jun 17, 2019 12:30 pm

I made the table using the icon on the bar at the top of the page. I am entering single letters and short words. Stuff like <B4> appears instead, and when I try to go to the next cell down, the program simply refuses, staying in the first cell in the column.

I am using the indexed search; the other search requires JRE.
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: converting to text

Postby robleyd » Mon Jun 17, 2019 2:54 pm

Can you upload a sample file that shows the issues you are having? [Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. The link also contains information on how to anonymise your document if it contains confidential information.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2932
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: converting to text

Postby oneota » Mon Jun 17, 2019 3:17 pm

An office-mate solved my problem: He said there was a red X that he clicked on.
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: converting to text

Postby Bill » Mon Jun 17, 2019 4:06 pm

Was that the red X on an error message?
AOO 4.1.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7319
Joined: Sat Nov 24, 2007 6:48 am

Re: converting to text

Postby oneota » Mon Jun 17, 2019 4:11 pm

I don't think so. when I asked him (a non-native speaker of English) to show me where it was, he sort of waved at the upper left (where spreadsheets have formulae etc.), but I didn't see it and didn't want to re-create it.
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: converting to text

Postby Lupp » Mon Jun 17, 2019 6:28 pm

Did you try to enter something starting with the character "=" or just this single character?
To start an input into an empty table cell tells Writer you want to create a formula. A subsequent click into any cell is interpreted as the wish to create a reference to the content of that cell...
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2527
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: [Solved] Converting to text

Postby oneota » Tue Jun 18, 2019 4:10 am

I only typed in
p
a
(for present and absent)
or single digits: 1, 9 etc.
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: Converting to text

Postby oneota » Tue Jun 18, 2019 4:21 am

Here is the file, with names altered.
Attachments
Intensive Lowest Class; Speaking 7 Listening, Summer 2019 Test.odt
(11.05 KiB) Downloaded 30 times
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: [Solved] Converting to text

Postby robleyd » Tue Jun 18, 2019 4:28 am

I'd imagine it looked like this, where I have typed = in the top left cell of the table:
table_formula.png
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2932
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Converting to text

Postby oneota » Tue Jun 18, 2019 4:48 am

I guess. So, when OO decides with-out my asking it to that instead of a simple table, I should have a spreadsheet, the red X is what I should click to have my table just be a table? I have made many tables in O with-out the automatic conversion, why did this suddenly happen? Has the software changed?
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: [Solved] Converting to text

Postby robleyd » Tue Jun 18, 2019 6:26 am

That will happen if you type an = in the cell, as I and Lupp both mentioned; or it will happen if you press F2. Writer takes that as the start of a simple formula and presents the formula input bar. Tables can contain simple formulae like a very basic spreadsheet.

If you inadvertently open the formula bar, yes, click on the X to close it again.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2932
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Converting to text

Postby oneota » Tue Jun 18, 2019 9:59 am

But I didn't press F2; nor did I enter = in a cell.
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: [Solved] Converting to text

Postby RoryOF » Tue Jun 18, 2019 10:03 am

With respect, this was your file, you drove the computer. We cannot read your mind, or know with any certainty what _you_ did.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29434
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Converting to text

Postby robleyd » Tue Jun 18, 2019 10:25 am

As far as I can determine from documentation and personal experimentation, only those two keys will invoke the formula bar in a Writer table; the ways to dismiss it are either click the red X or press the ESC key.

It may be that there is some special keyboard mapping, or some other 'feature' of your computer that causes it to behave differently. If that is the case we can't know about it.

I believe that the issue of how to exit the 'spreadsheet' has been resolved?

There is another feature of tables that you may wish to be aware of and possibly disable. See this entry in the documentation Wiki for more information.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2932
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Converting to text

Postby Villeroy » Tue Jun 18, 2019 11:33 am

You hit F2 instead of F1 with the cursor in a text table cell.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27095
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Converting to text

Postby oneota » Tue Jun 18, 2019 2:36 pm

No, I don't use the F keys in OO.
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: [Solved] Converting to text

Postby Bill » Tue Jun 18, 2019 4:36 pm

oneota wrote:But I didn't press F2; nor did I enter = in a cell.

Those are the only ways to open the Formula Bar. If the Formula Bar is no longer appearing after you closed it, then something associated with your system sent an F2 or = keystroke to OpenOffice to cause the Formula Bar to appear in the first place. If you think that something else caused the Formula Bar to appear, then it's up to you to tell us what that something was.

See the documentation:
Using spreadsheet functions in a table
AOO 4.1.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7319
Joined: Sat Nov 24, 2007 6:48 am

Re: [Solved] Converting to text

Postby oneota » Wed Jun 19, 2019 3:29 am

I can only tell what I did: I created a text document with a small amount of text, then I made a table using the table icon, pulling down the image until the desired number of cells appeared and I thus created a table. I wrote some text (labels across the top, names, and single letters and numbers in some cells), greyed the label row, copied the table and most of the text above it, pasted that material, changed one number in the text above the second table, added two rows and names, did a strike-through of two other names, added another table and changed the text above it. Then I added a single letter in the second table, and the spreadsheet function started. That's it.
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am

Re: [Solved] Converting to text

Postby Bill » Wed Jun 19, 2019 9:30 am

When you followed that procedure to test it, did the Formula Bar appear? It didin't when I tried.
AOO 4.1.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7319
Joined: Sat Nov 24, 2007 6:48 am

Re: [Solved] Converting to text

Postby oneota » Wed Jun 19, 2019 9:51 am

No, it didn't happen when I followed the procedure just now.
OOo 4.1.5 on Ms Windows 10
oneota
 
Posts: 25
Joined: Sun Sep 07, 2008 8:11 am


Return to Writer

Who is online

Users browsing this forum: No registered users and 31 guests