Created attachment 52670 [details]
Malformed input that LO accepts, leaving human wondering what's going on.
This is more of a question than a bug report, but I'm not sure where to "discuss" or ask this question.
Distilled from a legitimate case of a program outputting slightly malformed input, the question is "how strict should LO be about interpreting it's input?"
The attached document and screenshot showcase an example where a bit of ODS input is slightly malformed. This apparently doesn't bother LO, but certainly messes up the logic, as the background of the cells should be blue, not red (based on conditional formatting logic).
Content.xml is slightly malformed on lines 34 and 39. Line 39 is the more "insidious" case as the output within LO even passes the basic inspection of a human eye. (Click on cell C15, then click Format -> Conditional Formatting, and inspect the values. It /looks/ right, doesn't it?)
This is "broken" as far back as OpenOffice 3.2, but I don't have any interim LibO versions installed; I'm not sure what version to set the dial to for this bug report.
Recreated as of:
$ git log -1
Author: Bjoern Michaelsen <firstname.lastname@example.org>
Date: Sat Oct 22 12:36:07 2011 +0200
another fix for 68dd19a368fb4afbf3eba4cb722f56b87f8ea7c1 on OSX
And never sure what is helpful to a developer tracking down a bug, so:
$ uname -a
Linux hani 2.6.35-30-generic #60-Ubuntu SMP Mon Sep 19 20:42:44 UTC 2011 x86_64 GNU/Linux
$ gcc -v
Using built-in specs.
Configured with: ../configure --prefix=/usr/local --enable-ld=yes --enable-lto --enable-bootstrap
Thread model: posix
gcc version 4.6.1 (GCC)
Created attachment 52696 [details]
Doh! Forgot to include the screenshot last night. And the description in Comment 0 should read "cells should be blue, not green".
Thanks for bugreport
reproducible in 3.3.4 and 3.5.2 on Fedora 64 bit
changing version to 3.3.4 as most early reproduced
When save this file and reload again, it works correctly
IMHO it is functionality request for adding warning for user if in opened odt file is some problem
Just updating version to inherited from because of the OP stating that it's been an issue since OOo 3.2.
@Kevin - from what I can tell this is still a "problem." If you could confirm on 5.1 or later that'd be great.
Created attachment 126122 [details]
Malformed input as viewed in LO 220.127.116.11
Yes, it appears to be still an issue. What's more, either there's another malformed tidbit in the file, or LO now also does not show cell A4 (reference attached screenshot, where the content is shown in the input bar above, but not in the viewing area below).
For this test, I used the version packaged with Ubuntu Xenial. From the About dialog:
Build ID: 1:5.1.4-0ubuntu1
CPU Threads: 1; OS Version: Linux 4.4; UI Render: default;
Locale: en-US (C)