Editing Floats

[Terisa de morgan]

Originally Posted by BetterRed

The latter - I think

Say I do the bulk edit at 08:00 and set dates to today (2016-09-28), i.e. when it's 2016-09-27 22:00 UTC. It shows as '2016-09-28' in the Book List. But I press F2 on one of the Dates in the Book List the Edit Box shows '2016-09-27'.

However, say I do the bulk edit at 10:30 and set dates to today (2016-09-28), when it's 2016-09-28 00:30 UTC. It shows as '2016-09-28' in the Book List. When I press F2 on one of those Dates in the Book List the Edit Box shows '2016-09-28'.

It seems the problem occurs when the date is set in Bulk Edit at a time when my date is a day ahead of UTC date - but it only manifests when I edit one of the dates.

As I said its been driving me nuts for days.

BR

There's a similar problem with float. Say I have two books with prices set to 0,99. It I edit the single register, the price appears as 0,99. If I do a bulk edit, the price appears as 0. It looks like, in these cases, the recovered information is not quite proper.

[BetterRed]

Moderator Notice
Terisa de Morgan - I separated your post out to its own thread - it was in danger of getting lost in Aussies running frivolous commentary on the USA elections

BR

[chaley]

Originally Posted by Terisa de morgan

There's a similar problem with float. Say I have two books with prices set to 0,99. It I edit the single register, the price appears as 0,99. If I do a bulk edit, the price appears as 0. It looks like, in these cases, the recovered information is not quite proper.

I don't see this problem, at least as how I understand it. What I tried:

• Create a float custom column, without a formatting template.
• Enter values in the column in the spreadsheet. No problems.
• Use metadata edit (single) to edit the field. No problem.
• Select two books with the same value in the field and open bulk edit. I see the correct value in bulk edit. After changing the value I see the correct new value in the spreadsheet.
• Select books with different values in the column and launch bulk edit. This time I see (Undefined) in bulk edit. If I change the value then I see the new value in the spreadsheet.

I repeated these steps on a column with a formatting template with the same results.

I use a locale specifying "1,234.56". Your example implies that you are using a locale specifying "1 234,56". I don't know if I am interpreting your example correctly or if it makes any difference.

[Terisa de morgan]

Originally Posted by chaley

I don't see this problem, at least as how I understand it. What I tried:

• Create a float custom column, without a formatting template.
• Enter values in the column in the spreadsheet. No problems.
• Use metadata edit (single) to edit the field. No problem.
• Select two books with the same value in the field and open bulk edit. I see the correct value in bulk edit. After changing the value I see the correct new value in the spreadsheet.
• Select books with different values in the column and launch bulk edit. This time I see (Undefined) in bulk edit. If I change the value then I see the new value in the spreadsheet.

I repeated these steps on a column with a formatting template with the same results.

I use a locale specifying "1,234.56". Your example implies that you are using a locale specifying "1 234,56". I don't know if I am interpreting your example correctly or if it makes any difference.

My locale would be: 1.234,56 (Spanish configuration). I'll try to get a screenshot this evening (perhaps I'm wrong). And I have no template.