Border thickness changes between LO Calc and MS Excel

Bug #1180235 reported by Wayne Twine on 2013-05-15

This bug report will be marked for expiration in 56 days if no further activity occurs. (find out why)

20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
libreoffice (Ubuntu)
Undecided
Unassigned

Bug Description

Hi

I am running LO 3.5.7.2 and MS Office 2010 using Wine/Crossover in Ubuntu 12.04 .
I usually use LO Calc but have to use MS Excel when collaborating with colleagues because some formatting issues.

What I expect:
border thickness to be the same when opening a file in either Calc or Excel.

What happens instead:
1) If I set border in Calc spreadsheet to smooth line with thickness of 0.05 pt, save it in xlsx or xls format, and then open the file in Excel, the border appears as a fine dotted line in Excel.
2) If I set border in Excel spreadsheet to thinnest smooth line, save it in xlsx format, and then open the file in Calc, the line appears as a thick line (1.00 pt) in Calc.

Note: Line thickness does not change if I set it as fine line in Excel, save it in xls format, and then open in Calc.

Thanks

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice (not installed)
ProcVersionSignature: Ubuntu 3.2.0-41.66-generic 3.2.42
Uname: Linux 3.2.0-41-generic x86_64
ApportVersion: 2.0.1-0ubuntu17.2
Architecture: amd64
Date: Wed May 15 08:31:24 2013
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to precise on 2012-06-15 (333 days ago)

Wayne Twine (wayne-twine) wrote :
Wayne Twine (wayne-twine) wrote :

Just to add to my posting above: The same happens when opening or saving files in Excel 2007 on a Windows machine, so it's not a Wine bug.

Wayne Twine, thank you for reporting this and helping make Ubuntu better. Could you please attach a file made in Excel, before opening in LibreOffice, that demonstrates this problem?

Changed in libreoffice (Ubuntu):
status: New → Incomplete

Hi
Sure. Should I attach to this email or log onto Launchpad and paste it
there?

my new signature v3

Regards

Dr. Wayne Twine
Senior lecturer

School of Animal, Plant & Environmental Sciences
University of the Witwatersrand
c/o Wits Rural Facility
Private Bag X420
Acornhoek,1360
South Africa

Tel: +27 (0)15 793 7501
Fax: +27 (0)15 793 7509
<email address hidden>

/“//Two////men////look////out////the////same////prison////bars;////one////sees////mud////and////the////other////sees////stars.//”
/FrederickLangbridge(1849-1922)

On 15/05/13 12:48, Christopher M. Penalver wrote:
> Wayne Twine, thank you for reporting this and helping make Ubuntu
> better. Could you please attach a file made in Excel, before opening in
> LibreOffice, that demonstrates this problem?
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>

Wayne Twine (wayne-twine) wrote :

Oh, ok, I am new to Launchpad, so I didn't realise that the email I received was also posted here. Chris, is it possible to remove my reply to your email from this bug report so that my email address is not broadcast to all and sundry?

Anyway, attached is an .xlsx file created in Excel, with fine border lines. If you open in Calc, you will see that they are thicker (1.00 pt).

If you uncheck "use antialiasing" in LO options, the lines look a bit better (a bit more in focus), but are still too thick.

I hope this helps.

Wayne

Changed in libreoffice (Ubuntu):
status: Incomplete → New
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in libreoffice (Ubuntu):
status: New → Confirmed

This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know.

Changed in libreoffice (Ubuntu):
status: Confirmed → Incomplete
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers