Bug 59905

Please attach a document showing the behavior.

Marking as NEEDINFO - once you attach document mark as UNCONFIRMED and we will triage it

Created attachment 80349 [details]
Error Sample

Here is the sample file for the bug. 

You will notice that I have two DSUM formulas, the first one has an extra column and generates an error, the second one does not have an extra column and works fine.

Thanks for the additional info, changing version back as version reflects earliest confirmed version with the issue, we just use comments to say that it still exists on a newer release.

Thanks again

This is not a bug, from reading documentation we're following standards. I've never used DSUM before but I see that the issue is that if you include column N you have nothing to match O8 to because it's blank so it's spitting out errors. The error goes away if you remove one of the headers for your table (for instance delete D6, then you have blank=blank so it's matching up). From what I can tell this is all correct, if you know of documentation that this is wrong or if you know of software that behaves differently please let me know and I'll re-investigate.

Google Docs and Microsoft Excel both work with empty columns.


“The greater danger for most of us lies not in setting our aim too high and
falling short; but in setting our aim too low, and achieving our mark.” -
Michelangelo


On Tue, Sep 24, 2013 at 5:40 PM, <bugzilla-daemon@freedesktop.org> wrote:

>  Joel Madero <jmadero.dev@gmail.com> changed bug 59905<https://bugs.freedesktop.org/show_bug.cgi?id=59905>
>  What Removed Added  Status UNCONFIRMED RESOLVED  Resolution --- NOTABUG
>
>  *Comment # 4 <https://bugs.freedesktop.org/show_bug.cgi?id=59905#c4> on bug
> 59905 <https://bugs.freedesktop.org/show_bug.cgi?id=59905> from Joel
> Madero <jmadero.dev@gmail.com> *
>
> This is not a bug, from reading documentation we're following standards. I've
> never used DSUM before but I see that the issue is that if you include column N
> you have nothing to match O8 to because it's blank so it's spitting out errors.
> The error goes away if you remove one of the headers for your table (for
> instance delete D6, then you have blank=blank so it's matching up). From what I
> can tell this is all correct, if you know of documentation that this is wrong
> or if you know of software that behaves differently please let me know and I'll
> re-investigate.
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>

In the future please don't respond via email as it just ads clutter to bug comments (similar with extra quotes that don't add to the issue at hand). I'll mark this back to UNCONFIRMED and investigate a bit

My bad, sorry about the garbage. :/

No worries, we're trying to get our bug tracker to explicitly say "don't respond via email" but as of now it's just a hidden request by QA that we try to include to avoid comments becoming incomprehensible- not your fault at all. (Also my mistake for saying "ad" instead of "add").

Cannot change font in headers on the LibreOffice spreadsheets.

@Drew - how is that related to this bug? Also please don't change the priorities without knowing our workflow - thanks!