[Bug 631857] Re: Conditional Formatting does not work properly
Sorry for my stubornness. I did not try (double quotes). Using single quotes changes the content of the fields (A becomes a sometimes). It works like described, thanks -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
Wolf Rogner, the same solution in comment #6 also applies to Natty. lsb_release -rd Description:Ubuntu 11.04 Release:11.04 apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.3-1ubuntu2 Candidate: 1:3.3.3-1ubuntu2 Version table: *** 1:3.3.3-1ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.3.2-1ubuntu4 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
In Natty it does not work. Simpy, there is no conditional formatting. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
Wolf Rogner, according to: http://help.libreoffice.org/Calc/Applying_Conditional_Formatting It clearly states: To Define the Conditions Select the cells to which you want to apply a conditional style. So, only selecting cells A1:A3, applying the desired Conditional Formatting, and expecting it to apply to columns A and B are invalid. The same rationale holds true for OpenOffice according to: documentation.openoffice.org/HOW_TO/spreadsheet/calc3_EN.pdf Feel free to report any future bugs you may find. ** Changed in: libreoffice (Ubuntu) Status: Confirmed = Invalid ** Changed in: openoffice.org (Ubuntu) Status: New = Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
Wolf Rogner (war-rsb), if one wants to use Conditional Formatting to change the background of cell A1 containing an uppercase A to green, and cell A2 containing an uppercase B to yellow one may perform at the Terminal: localc -nologo highlight cells A1 through A3 - click Format - Conditional Formatting... - Condition 1 checkbox checked - Cell value in dropdown box - equal to in dropdown box - in field type A (include the double quotes) - click New style... button - in Cell Style window click Background tab - click Green - click OK button - Condition 2 checkbox checked - Cell value is in dropdown box - equal to in dropdown box - in field type B (include the double quotes) - click New style... button - in Cell Style window click Background tab - click Yellow - click OK button - in Conditional Formatting window clicked OK button and notice A1 background is green, A2 is yellow, and A3 is not changed. lsb_release -rd Description: Ubuntu oneiric (development branch) Release: 11.10 apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.4.2-2ubuntu3 Candidate: 1:3.4.2-2ubuntu3 Version table: *** 1:3.4.2-2ubuntu3 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages 100 /var/lib/dpkg/status -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Changed in: df-libreoffice Status: Fix Released = Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Changed in: df-libreoffice Status: Invalid = Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Changed in: df-libreoffice Status: Confirmed = Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Changed in: libreoffice (Ubuntu) Status: New = Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Project changed: libreoffice = df-libreoffice -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Changed in: libreoffice Importance: Unknown = Low -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Also affects: libreoffice (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Description changed: Binary package hint: gvfs - Formatting a cell with conditional format does not work. - Neither formula nor value at that + Open up fresh spreadsheet, highlight only A1 through A3, click Format - + Conditional Formatting... - Condition 1 checkbox checked (was by + default) - Cell value in dropdown box - equal to in dropdown box - in + field type A - Cell Style dropdown box is Default (was Default by + default) - click New style... button - in Cell Style window click + Background tab - click Green - click OK button + + *** Notice Cell Style drop downbox box for Condition 1 changed itself + from Default to Untitled1 + + - Click Condition 2 checkbox - Cell value is in dropdown box - equal + to in dropdown box - in field type B - Cell Style dropdown box is + Default (was Default by default) - click New style... button - in Cell + Style window click Background tab - click Yellow - click OK button + + *** Notice Cell Style drop downbox box for Condition 1 changed itself + from Default to Untitled2 + + - in Conditional Formatting window clicked OK button. + + Cells in column A B are not green yellow respectively. ProblemType: Bug DistroRelease: Ubuntu 10.04 Package: gvfs 1.6.1-0ubuntu1build1 ProcVersionSignature: Ubuntu 2.6.32-24.42-generic 2.6.32.15+drm33.5 Uname: Linux 2.6.32-24-generic x86_64 NonfreeKernelModules: nvidia Architecture: amd64 Date: Mon Sep 6 20:46:51 2010 InstallationMedia: Ubuntu 9.10 Karmic Koala - Release Candidate amd64 (20091020.3) ProcEnviron: - LANGUAGE=en_GB:en - LANG=en_GB.utf8 - SHELL=/bin/bash + LANGUAGE=en_GB:en + LANG=en_GB.utf8 + SHELL=/bin/bash SourcePackage: gvfs Symptom: storage Title: Documents cannot be opened in desktop UI on storage device ** Bug watch added: freedesktop.org Bugzilla #33814 http://bugs.freedesktop.org/show_bug.cgi?id=33814 ** Also affects: libreoffice via http://bugs.freedesktop.org/show_bug.cgi?id=33814 Importance: Unknown Status: Unknown -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 631857] Re: Conditional Formatting does not work properly
** Changed in: libreoffice Status: Unknown = Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs