![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
When you freeze a row or column in Calc
http://help.libreoffice.org/Calc/Freezing_Rows_or_Columns_as_Headers
is there a way to save that as a permanent state? I've tried freezing and
after a few minutes I managed to get it to work but when I save and close
the file it opens again unfrozen.
Then we need more information about your set up: operating system?
version of LO? 32 bit or 64 bit? Is the spreadsheet an Excel workbook?
How many sheets do you have in the file? How many of these sheets have
the rows or columns frozen?
Something is different about your setup that is causing this
because you are not getting the standard results.
For the last 8 years or perhaps more, a Calc (originally .sxc;
now .ods) spreadsheet would preserve the "Window > Freeze" when the file
was saved.
--Dan
Well my mom just sent me a spreadsheet she's doing. Created on her MacBook
10.5 i think. Should be the latest version of LO.
I was working on my Win7 64bit Dell computer here. Ver 3.4.4. These were
.ods files. Simple simple stuff here.. Only using one (of three default)
sheet. Less than 100 rows, trying to freeze the top row.
Hi 
Move the cursor down to the 2nd row and then try
Window - Freeze
If it's not the right cell then you can undo it by selecting
Window - Freeze
again.
I usually select cell B2 or thereabouts so that when i scroll horizontally i can still see the headings in Column A as well as Row 1.
Regards from
Tom
Thanks Tom I did actually figure that part out. It was just when i saved
and closed the file. I tried to open it again and the row wasn't frozen. I
assumed that was intentionally and didn't know how to change it. Now i see
that it was a bug and i need to reassess my results.
Am 10.05.2012 14:29, The Wolfkin wrote:
Thanks Tom I did actually figure that part out. It was just when i saved
and closed the file. I tried to open it again and the row wasn't frozen. I
assumed that was intentionally and didn't know how to change it. Now i see
that it was a bug and i need to reassess my results.
You forgot to mention that you save in some foreign format.
Am 10.05.2012 21:33, Andreas Säger wrote:
You forgot to mention that you save in some foreign format.
Obviously you do even save in xlsx which is the worst choice.
normally I do .. but in this case it was in .ods format.. I'm positive I
mentioned that earlier. I just checked. it was my second message. These
were .ods files to repeat myself. In the other thread on defaults I did
mention that I prefer to default to Office formats but that happened to not
be the case here. I spend a lot of time dealing with people who are not ..
quite adept with technology. I would never have left out such a major
detail.
I'm confused because as far as I can tell in this thread you're the first
person to even mention xlsx or xls. I don't think I mentioned that file
format in the other thread.
Hi
Don't worry about Andreas' strangeness. There are a few people on this list that like to bully new people and create a bad atmosphere presumably to drive people away from LibreOffice.
Regards from
Tom
Am 10.05.2012 23:38, The Wolfkin wrote:
I'm confused because as far as I can tell in this thread you're the first
person to even mention xlsx or xls. I don't think I mentioned that file
format in the other thread.
In your other topic you mentioned that you save in foreign file formats by default. Anyone can save a new spreadsheet with frozen panes as xlsx, reopen and see that frozen panes in xlsx give "interesting" visual effects when loaded into any version of LibreOffice or OpenOffice.
These file formats are not free. Despite their "XML openess" they are designed to be as difficult (incompatible) as can be. OOXML has been designed to fight the ODF standard and to increase the level of incompatibility to other office applications.
You must not use OOXML with this software. If the latest MS document format is important for your work, simply get a cheap version of Excel in order to get rid of all the trouble (frozen panes belong to the least important group of problems).
Am 10.05.2012 23:38, The Wolfkin wrote:
I'm confused because as far as I can tell in this thread you're the first
person to even mention xlsx or xls. I don't think I mentioned that file
format in the other thread.
By the way: The Gnumeric spreadsheet saves xlsx with frozen panes flawlessly.
The developers of that excellent spreadsheet program concentrate on a much smaller set of features and attributes. The whole application mimics a subset of Excel.
Of course Gnumeric does not support as many non-spreadsheet features as Calc does. Misusing Gnumeric as database surrogate is even more absurd than in Calc and Excel.
Hi
Ahhh, i take it back then. I didn't realise Gnumeric is better at doing MS Formats. The only thing i noticed was that it couldn't be set to default to saving as MS Formats or anything else. I had to use "Save As", not a big problem for me but colleagues found that a hopelessly geeky thing to do.
Regards from
Tom
Am 11.05.2012 16:09, Tom Davies wrote:
Hi
Ahhh, i take it back then. I didn't realise Gnumeric is better at doing MS Formats. The only thing i noticed was that it couldn't be set to default to saving as MS Formats or anything else. I had to use "Save As", not a big problem for me but colleagues found that a hopelessly geeky thing to do.
Regards from
Tom
Same problem as with any other software. Incremental updates may accumulate conversion errors. So you better work with the supposed native format and convert when someone else needs a copy of the current state of your document. The File>Send>... commands in LibreOffice make this very easy and there are good reasons why it is File>Send>"Document as *.doc" instead of *.docx.
fair enough but a) I had *deliberately *stated in this thread that it was
.ods and b) in the other thread I wasn't championing OOXML but lamenting
that others give it to me to work with. I'm no expert by far but I'm
actually pretty aware of the issues with OOXML vs ODF. I would never have
asked for help with an issue based on using a foreign file format without
saying so. With my simple needs, when people send me .doc .xls (this is
what I meant when i wanted to save in foreign formats), they have generally
worked fine.
With spreadsheets I just needs cells for ordering, the ability to merge and
resize the cells, and maybe some simple math (not often). I rarely deal
with graphs from other people ( my personal graphs start and end in LO),
and text formatting beyond compatible fonts almost never is an issue. Again
I (when working with others) never stray beyond a single sheet per document
or more than 100 cells in either direction.
With documents my needs can be more varied but I understand that they won't
come out right and I expect and accept that.
> When you freeze a row or column in Calc
>
> http://help.libreoffice.org/Calc/Freezing_Rows_or_Columns_as_Headers
>
> is there a way to save that as a permanent state? I've tried freezing
and
> after a few minutes I managed to get it to work but when I save and
close
> the file it opens again unfrozen.
>
> --
> Wolfkin
> http://about.me/wolfkinThen we need more information about your set up: operating system?
version of LO? 32 bit or 64 bit? Is the spreadsheet an Excel workbook?
How many sheets do you have in the file? How many of these sheets have
the rows or columns frozen?
Something is different about your setup that is causing this
because you are not getting the standard results.
For the last 8 years or perhaps more, a Calc (originally .sxc;
now .ods) spreadsheet would preserve the "Window > Freeze" when the file
was saved.--Dan
I'm having the same problem. Also, have this problem with some of the data
validity settings (the 'Allow' criteria flags not maintaining state).
Could this be because I'm saving the file as '.xls'?
I'm running LO 4.0.1.2 on a 64 bit Chrome machine.
3 of the 7 sheets have frozen rows and columns.
Thanks,
Dave
Hi "The Wolfkin",
try resetting the user profile, many times solve strange issues.