Re: OpenOffice.org calc -- entered data "disappears"
Update:
Fiddling around with the text color (Setting "Automatic" to something
else) will show the data in the spreadsheet until I set it back and
nothing seems to affect the text/foreground color for the edit control
in the toolbar.
-- darin
--- darin strait <darin_strait@yahoo.com> wrote:
> It's not so dumb of a question.
>
> If I bring up an old spreadsheet, highlight the spreadsheet area,
> bring
> up the color picker, "Automatic" is highlighted. If I choose "Blue"
> ("Black" will not work), I can see the data in the spreadsheet area
> as
> I would expect. I can then re-choose "Automatic", and the data
> remains
> visible.
>
> If I start a New spreadsheet I need to switch to Blue and then back
> to
> Automatic, even for just one cell, and then Calc seems to work as I'd
> expect.
>
> I'm not sure what "automatic" really means. I tend not to tweak the
> colors in my spreadsheets much.
>
> This is not a good solution for the following reasons:
> 1. This destroys any color selections that may have been made by
> people
> I receive spreadsheets from. I'm particularly concerned with
> spreadsheets that are native Excel spreadsheets.
> 2. I still can't see anything in the entry field in the toolbar area.
> This means that I can't view formulas, which is show-stopping for me.
>
> Is there some option buried in menu/dialogs that lets me chose
> "automatic" over something else?
>
> Is there an option that lets me set the text color in the edit field
> in
> the toolbar?
>
> -- darin
>
> --- Jason Bleazard <jason.debian@bleazard.net> wrote:
>
> > On Fri, February 25, 2005 12:39 pm, darin strait said:
> > >
> > > If I open an XLS file or an old calc spreadsheet, the spreadsheet
> > > appears to be empty.
> > >
> > > When I enter a new value (a number, a formula or just plain text)
> > into
> > > a cell in the spreadsheet and hit enter, the value disappears.
> > >
> > > If I edit the cell, it appears as if nothing was entered. The
> > problem
> > > seems to affect every cell in the spreadsheet.
> >
> > This may be a dumb question, but it isn't by any chance setting
> your
> > font
> > color to white text on a white background, is it? I've never used
> > OpenOffice, but I've had similar things happen in other programs.
> > Might
> > be worth a quick check.
> >
> > Jason
> >
> >
> >
>
>
> =====
> darin_strait@yahoo.com
> Database Development and Administration
>
> "I am always willing to run some hazard of being tedious, in order to
> be sure that I am perspicuous" Adam Smith
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> --
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact
> listmaster@lists.debian.org
>
>
=====
darin_strait@yahoo.com
Database Development and Administration
"I am always willing to run some hazard of being tedious, in order to be sure that I am perspicuous" Adam Smith
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Reply to: