Ask Your Question
1

New User - Minor bugs in OO spreadsheets [closed]

asked 2012-07-25 11:25:19 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Have used OpenOffice for six years and have several hundred documents--mostly spreadsheet. Some are moderately complex with lots of columns, special formatting, formulas, and links to other spreadsheets that update cells upon open.

Interested in switching to LibreOffice, I recently installed it and opened a couple test files. Two observations need help with:

  1. Column headings where I have added a default .05 pt bottom border in the first cell translate to a much thicker 1.0 pt bottom border.

  2. The light-grey cell outlines present by default in any new spreadsheet are missing in some cells. It's pretty haphazard. In some cells its missing on all four sides; in others just one or two sides. A comparison of cell Format settings turns up no difference between effected and normal cells.

Philosophically, I support LIbreOffice and would like to switch. Although these bugs may sound minor, I was looking for a more straightforward switch--one that would not require me to spend hours modifying border thickness in hundreds of cells.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 01:44:12.719258

Comments

manj_k gravatar imagemanj_k ( 2013-06-24 21:57:51 +0200 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2012-07-25 13:34:30 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

  1. If the actual numbers change, this is probably a bug. Please research if you can find it here, if not, please file a bug – either through the Assistant or directly on bugs.freedesktop.org)
  2. This might be caused by background colours being set on those cells. To enable the gridlines everywhere again, go to Tools, Options..., choose View under LibreOffice Calc, and set Grid Lines to "Show on coloured cells"
edit flag offensive delete link more

Comments

Install older versions of LibreOffice to find out when this bug was introduced: http://downloadarchive.documentfoundation.org/libreoffice/old/

Björgvin gravatar imageBjörgvin ( 2012-07-25 17:39:46 +0200 )edit
0

answered 2012-07-25 17:37:48 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Install older versions of LibreOffice to find out exactly when the bug was introduced: http://downloadarchive.documentfoundation.org/libreoffice/old/

edit flag offensive delete link more

Comments

If the bug is not present in an early build of 3.5, we might be able to use the handy-dandy bibisect tool to track this down (http://wiki.documentfoundation.org/QA/HowToBibisect)

qubit gravatar imagequbit ( 2012-07-26 05:21:00 +0200 )edit
0

answered 2012-07-26 20:09:46 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Astron, Major thanks. Solution 2 did the trick to bring back my grid lines.

I will try an earlier Ver. to see when the Border thickness issue first surfaced. I was running a slightly older version of OO (Ver. 3.2.1) if that helps.

Thanks again.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-07-25 11:25:19 +0200

Seen: 307 times

Last updated: Jul 26 '12