Had you meant to attach a file? Anyway, this is certainly highly unusual behavior, not at all what
I've ever seen (admittedly, I'm only a very casual user of Calc). I built a simple spreadsheet with
some empty cells and could not reproduce this behavior (Windows 7 64-bit, OOo 3.1.1). This is such
an obvious and dramatic problem that there should have been tons of messages about it, and there
haven't been any. So it seems likely that it's something about either your spreadsheet or your
configuration that is causing this, and if you can supply the file we can at least see if any such
thing happens for anybody else.
On 11/30/2010 12:52 PM, Frank Altamirano wrote:
I'm working on a HP, MS Windows 7 64bit and am working with OOs v3.2.1 and my
issues are with Calc.
I'm setting up a very simple spreadsheet for a song list for church. Its just a basic list of
songs and there corresponding versions in Spanish and Italian. Now most of column A is filled in
(e.g. A48) but if a cell is empty to the left of it (e.g. B48, C48, D48) the following happens.
After saving and reopening wherever there was an empty cell it would shift all cells to the left
to fill in the empty cells, thus, messing up entire order. To temporarily solve the issue, so that
i can actually save all they work i have put in, I found that if I just put a "space bar"
character in all empty cells it would serve as a place holder and no cells would shift.
).
However, in testing the sheet again before sending it to you, I deleted some of the spaces from
the empty cells, saved, closed and reopened... expecting the cells to shift, however, they did not.
The issue was reproduced on row 554 when i entered characters into A554, left B554 blank, and
entered data into C554. Once I saved and reopened, the data that was C554 had shifted to B554.
Please help
On Thu, Nov 25, 2010 at 2:43 PM, Barbara Duprey <[email protected]
<mailto:[email protected]>> wrote:
On 11/24/2010 7:50 PM, Frank Altamirano wrote:
I'm having a major problem with my spreadsheet and i want to try to log
on
to your site and its says it cant find my email then i go to software
and
open the link from there to register and it says i can't because my
email is
already registered. UUUGGHHH PLEASE HELP
[Frank ([email protected] <mailto:[email protected]>) is
not subscribed and
will probably not see any responses unless directly copied.]
First, you should have no need to register or log on to the site -- if you
got OpenOffice.org
from a site other than www.openoffice.org <http://www.openoffice.org>, that
may be the
beginning of the problem. Registration is optional during the installation
process, but has no
function operationally, it's just trying to get statistics about how many
users there are.
If you describe your problem here, including what operating system and
version, and what
version of OOo you are using, and as much as possible about the details of
the problem and how
you've tried to solve it, the users on this mailing list will try our best
to help you.
--
Regards,
Frank Altamirano
tel 201.719.3007
